. make sure that if there
are any open files that they are closed.
Cheers,
Simon
On 23 October 2017 at 14:38, Scott Thornton
<scott.thorn...@hnehealth.nsw.gov.au<mailto:scott.thorn...@hnehealth.nsw.gov.au>>
wrote:
Hi,
( In case anyone is still subscribed to cfaussie )
I have re
Hi,
( In case anyone is still subscribed to cfaussie )
I have recently moved some code from cf6 to cf9 enterprise and a particular
process consumes all of the resources and hangs the CF server. The exact same
code on CF9 standard works okay ( although different windows server version ).
The
HI Guys,
That post was from 2010!
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of
Mike K
Sent: Friday, 4 November 2016 8:21 AM
To: cfaussie
Subject: Re: [cfaussie] Re: Strange problem - Element RECORDCOUNT is undefined
in query
Have you run the query in your
sulting page of
carehart.org.
/charlie
From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>
[mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton
Sent: Monday, March 14, 2016 7:51 PM
To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>
Subject: RE: [cfaussie] Upd
[mailto:cfaussie@googlegroups.com] On Behalf Of
Mike K
Sent: Tuesday, 15 March 2016 11:25 AM
To: cfaussie
Subject: Re: [cfaussie] Update to CF 9.0.2
I have the WIn64 installer for CF9.0.2 if you want it.
On Tue, Mar 15, 2016 at 10:58 AM, Scott Thornton
<scott.thorn...@hnehealth.nsw.gov
://www.gpickin.com/cfrepo/ , however the
View Files link https://copy.com/nhIbHZYZnmPN doesn't appear to work currently.
Could anyone provide any advice on obtaining the updater if possible?
Scott Thornton, Platypus2
Phone: 498 53361 Fax: 498 53364
--
You received this message because you
Hi,
I still use Crystal reports, rather than CFReport.
But, is there any possibility you could add an additional detail line to the
report, and display it conditionally when the big field needs to be displayed?
OR
Can you not set the field to can grow vertically ( another crystal report
Subject: Re: [cfaussie] Unable to read WSDL from URL
Hi Scott,
This seems to be a well known bug:
https://bugbase.adobe.com/index.cfm?event=bugid=3531653
https://forums.adobe.com/message/5207697
Cheers,
Dmitry,
On 10/07/2014 10:37 AM, Scott Thornton wrote:
Hi,
I am working with webservices
at 3:29 PM, Scott Thornton
scott.thorn...@hnehealth.nsw.gov.aumailto:scott.thorn...@hnehealth.nsw.gov.au
wrote:
Hi,
Your suggestion works, passing it in via URL.
If I use my domain credentials it returns:
usernamesuccess
I guess it might have something to do with the cffunction returning
Hi,
I am working with webservices for the first time, and my knowledge is very
rudimentary.
Scenario:
I need to implement NT Authentication on my intranet app. My CF6.1 server can't
process the cfntauthenticate tag.
I also have a CF9 9,0,1,274733 server that I can use to process a
@googlegroups.commailto:cfaussie@googlegroups.com
[mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton
Sent: Wednesday, July 09, 2014 8:37 PM
To: cfaussie@googlegroups.commailto:cfaussie@googlegroups.com
Subject: [cfaussie] Unable to read WSDL from URL
Hi,
I am working with webservices
Hi,
Sorry, yes this option is already selected.
The server is running on 32-bit.
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of
Andrew Scott
Sent: Thursday, 10 July 2014 2:44 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Unable to read WSDL from URL
Hi,
After deleting the stubs in C:\ColdFusion9\stubs\WS854518475\login
I was able to get the wsdl to generate ( see below )
The CFinvoke statement returns an error however:
cfinvoke
webservice=http://localhost/login/NTLoginService.cfc?wsdl;
Hi,
Your suggestion works, passing it in via URL.
If I use my domain credentials it returns:
usernamesuccess
I guess it might have something to do with the cffunction returning a struct (
the cfauthenticate result ). I may have to simplify that.
Do coldfusion RESTful webservices work in CF
Hi,
You could read the .csv line by line, using CFFILE , but it can be pretty slow.
( There are probably fancier\faster ways )
Eg.
!--- get a list of csv files ---
cfdirectory
action=List
directory=mydirectory
name=myfiles
filter=*.csv
!---
Hi
A recent database upgrade from MS SQL2005 to 2012 has caused ( I believe) the
following error to occur intermittently ( about 10 times today):
Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The
requested instance is either invalid or not running.
Hi Charlie\Carl,
Yes that was the problem. The number of form fields needed to be increased.
I am emailing as it didn't see Joel's post come throught the email
notification. He did post on the googlegroup website apparently though.
Thanks for your quick responses, we would never had figured it
Apologies, I should I have mentioned I have Firebug ( and yslow ), but have yet
to figure out to display a timing for each of the components of the web page.
…….
Scrap that, I have just seen the components option under Firebug ( I was
stuffing around in ySlow orginally) and now see the
Bar codes are just fonts.
In the past I have used a font to display Bar Codes generated in Crystal
reports.
A standard format for the code must be defined for item you are scanning, eg
length and pre and postfix characters.
For example a Medical Record Number (I work in health) might
@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of
Scott Thornton
Sent: Monday, January 30, 2012 11:23 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] RE: Attribute validation error for tag cfoutput
I changed my code to work within a cfloop ( which it should have been anyway
[mailto:cfaussie@googlegroups.com] On Behalf Of
Scott Thornton
Sent: Tuesday, January 31, 2012 4:27 PM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] RE: Attribute validation error for tag cfoutput
Hi Charlie,
Thanks as always for your continued support of the CFAussie forum. I always
appreaciate your
G'day,
A strange problem just cropped up in one of my live systems ( CF 9 ).
This page works on a CFMX6.1 server ( against a different database ).
The page works when I run it locally ( cf 9 against the same datbase )
When I look at the debug output for the page, I can see that the query
I changed my code to work within a cfloop ( which it should have been anyway ),
and it works okay.
--
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
Hi,
Is anyone aware of any great client side eurodate validation plugins for jquery?
eg:
Valid: 01/01/01, 01-01-01, 01/Jan/2001, 29-Feb-2012
Invalid: 31-Mar-2001, 29-Feb-2011
I am looking for more then just a regex, to acutally parse and verify the date.
I'd really rather not have to build
Hi,
CF MX 6.1 has a log file named scheduler.log available in cf admin.
CF 9 standard, doesn't appear to have one at all
Can you tell me should it exist, or perhaps the logged information goes into
one of the other log files now?
Thanks,
--
You received this message because you are
under Debugging Logging Logging
Settings
From: Scott Thornton [mailto:scott.thorn...@hnehealth.nsw.gov.au]
Sent: Tuesday, 14 June 2011 2:18 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Scheduled Tasks - Where is the log file?
Hi,
CF MX 6.1 has a log file named scheduler.log available
Hi,
Do you guys actually use CF builder?
I wanted to give proper debugging another go, installed CF builder 1 three
weeks ago and attempted to get started.
To be fair, its an environment that I am not famaliar with, but it seems so
slow, so hard to do anything in it, I have so many questions
is jsphandler, which
is mapped to *.jsp
This is from our Enterprise CF 9 on IIS 7.
It'd be easy enough to check for other configurations (standalone etc)
by downloading and installing it as a developer edition
Cheers
Paul
On Thu, Apr 14, 2011 at 10:56 AM, Scott Thornton
scott.thorn
Hello,
Quick off topic question,
Can an IIS server running CF 9 also run .jsp pages?
I am guessing not, and that it would need another server software... like
apache or something?
I don't know anything about jsp obviously
--
You received this message because you are subscribed to the
Hi,
Is the www.fullasagoog.com website still working?
The last post I have is from 6 days ago entitled - cf.Objective() 2011 - Call
for Pecha Kucha Speakers and BoF Survey Now
Openhttp://www.fullasagoog.com/182FDAD0-4EC8-11E0-88D2005056B0691C/redirect
--
You received this message because
Hello,
Couldn't you summarise your data in your query the first place?
eg:
select
left(datename(month, my_date ),3) +'-'+ datename( year, my_date) as period,
count( of something ) as my_count
from
my_table
group by
left(datename(month, my_date ),3) +'-'+ datename( year, my_date)
( MS
wrote:
No you don’t need to always use jQuery, you can even look at using the
cfajaxproxy tag to do what you need.
Regards,
Andrew Scott
http://www.andyscott.id.au/
From: cfaussie@googlegroups.commailto:cfaussie@googlegroups.com
[mailto:cfaus...@googlegroups.com] On Behalf Of Scott Thornton
Hello,
I am looking for a solution that will allow Ajax-y style updates of a database
when a user changes a value in one of many select boxes in a form.
EG: Say there are 20 select boxes in a form with Yes or No Options. Changing
the value will perform a database update without the usual form
Hello,
A few things..
Reports written in Crystal Reports ( 8,9, 11 etc) do not work with the CFREPORT
tag.
My understanding is that Report Builder is a cut down version of Crytsal
Reports and is missing some functionality. The reports are not interchangeable
between products btw.
You CAN
Hi,
Running across a odd problem in CF 9,0,0,251028. development server.
I was just running a process that usually works and has not been modified for
quite a long time. part of that process runs a query and then loops over the
result set. Simple enough... however the query does not seem to
2010 9:41 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in
query
What happens if you try CFDUMP instead right after the query?
On 1/10/2010 9:35 AM, Scott Thornton wrote:
Hi,
Running across a odd problem in CF 9,0,0,251028. development
Hello,
Thanks for all replies.
An update of my local dev server to 9,0,1,274733 appears to have solved the
problem.
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of
Scott Thornton
Sent: Friday, 1 October 2010 10:29 AM
To: cfaussie@googlegroups.com
Subject: RE
in case you didn't already know.
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options,
[tablename_UPDATE]
ON[dbo].[tablename]
FOR UPDATE
AS
/*
Author: Scott Thornton
Date: 05-07-2005
Desc: For each field modified on the x table, insert a record into the Audit
log table
and show the value of the filed before and after the update.
*/
set nocount on
SET DATEFORMAT DMY
DECLARE
I have seen similar behaviour, I think it was with CF 8.
Using the Set nocount on option seemed to help.
cfquery datasource=ds name=qInsert
set nocount on
INSERT
INTO TableName (Col1)
VALUES ('foobar')
SELECT @@IDENTITY AS 'NewID'
Set nocount off
/cfquery
PS: SCOPE_IDENTITY() is a better
Hi,
FileMon and ProcMon ( formerly from a company named SysInternals) are
now owned by Microsoft.
Good utilities they are.
www.sysinternals.com
Gavin Baumanis beauecli...@gmail.com 20/07/2010 10:22 am
Try stopping the CF service and any other service that might be using
those files.
then you
Hi,
Anyone else having trouble seeing the Adobe website
http://www.adobe.com/products/livecycle/forms/ ?
I have been asked to review an Analysis document for a project that includes
livecycle, but am struggling to find out what it does.
The costs seem quite high, and I wanted to see what it
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
On Tue, Jun 8, 2010 at 2:15 PM, Gavin Baumanis beauecli...@gmail.comwrote:
Hi All,
On Jun 8, 2:06 pm, Scott Thornton
scott.thorn...@hnehealth.nsw.gov.au wrote:
Hi,
pretty sure
Hi,
pretty sure that collation refers to sort order.
Language refers to date format however, but I could not find a server wide
setting to change it.
SELECT @@LANGUAGE AS 'Language Name' returns us_english in my SQL 2005 server.
If the language was British it would default to dmy
select *
Hi,
I was hoping to achieve something rather simple ( I thought), which was to
display on a webpage the xml stored from within a database, in hopefully a
formatted manner.
The XML is stored unformatted within a database text field.
When I save the following XML a text document with an .xml
.
On Mon, Jun 7, 2010 at 2:18 PM, Scott Thornton
scott.thorn...@hnehealth.nsw.gov.au wrote:
Hi,
I was hoping to achieve something rather simple ( I thought), which was to
display on a webpage the xml stored from within a database, in hopefully a
formatted manner.
The XML is stored
, in message 4c0c7794.1070...@ampersand.net.au,
m...@ampersand.net.au m...@ampersand.net.au wrote:
How about #replace(query.xml,,lt;,all)#
Dodgy I know but does it work?
On 7/06/2010 2:29 PM, Scott Thornton wrote:
Thanks, however:
cfcontent variable=#query.xml#
returns:
Attribute validation error
Hi,
I have now. it will also need special formatting to make it more readable.
Blair McKenzie shi...@gmail.com 07/06/2010 2:50 pm
Have you tried the htmleditformat function?
On Mon, Jun 7, 2010 at 2:44 PM, Scott Thornton
scott.thorn...@hnehealth.nsw.gov.au wrote:
Hi,
interestingly
Hi,
do you have any events on the 01-jun ? I am down that way for a meeting... I'd
guess not but
Peter Robertson pe...@p-robertson.com 20/05/2010 10:13 am
If you're attending the CFUG in Melbourne this month, please don't
roll up tonight, we've postponed to next week to accommodate
I have been yes.
Steve Onnis st...@cfcentral.com.au 19/05/2010 11:10 am
Is anyone else getting bounce emails from Mike Gardiner or is it just me?
Steve
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to
from a CF server.
Cheers
Kai
On 17/05/2010, at 2:03 PM, Scott Thornton wrote:
Hi,
I have a bunch or mail sitting in my spool directory un-sent from over the
weekend.
Obviously something is not working. Is it possible to 'restart' the cfmail
process without re-starting the entire CF
9 is much the same. I wonder if they'd consider an enhancement request?
Kym Kovan dev-li...@mbcomms.net.au 17/05/2010 4:58 pm
On 17/05/2010 16:30, Scott Thornton wrote:
Hi,
Nothing unusual on logs
I am, since last week. The spool checking stooped last Friday at 4:45pm
then nothing
the tie that binds?
/charlie
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On
Behalf Of Scott Thornton
Sent: Monday, May 17, 2010 6:14 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] CF Mail problem
Hello,
A restart
Hi,
google searches indicate that the .restart() method might be available from 7
onwards.
I am updating my servers soon to 9, so Ill see if I can implement something
then..
nkosi glenrainb...@gmail.com 18/05/2010 11:25 am
Hi Scott,
I can't remember if you can get a hold of ColdFusion's
Hello Bryce,
I see you are from Newcastle too.. I didn't realise the Council also used CF.
Finally there is another person using CF ( outside of HNEAHS that is.) :
Bryce Hoffmann bhoffm...@ncc.nsw.gov.au 13/05/2010 11:21 am
Try putting the domain in front of your 'myusername' as in
Builder seemed a good fit.
What do you use?
Scott Thornton, Acting System Administrator
Centralised Billing Unit
Hunter-New England Area Health Service
ext: 53361 p: +61 02 498 53361 m: 0413 800 242
--
You received this message because you are subscribed to the Google Groups
cfaussie
.
Brian
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of
Scott Thornton
Sent: Friday, 16 April 2010 11:34 AM
To: 'cfaussie@googlegroups.com'
Subject: RE: [cfaussie] cfmamil problem
Hi,
thanks for your reply.
the log is absolutely bare
is going wrong, and, what can I do to fix it?
Scott Thornton, Centralised Billing Unit
Hunter-New England Area Health Service
ext: 53358 p: +61 02 498 53358 m: 0413 800 242
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email
.
Scott Thornton, Centralised Billing Unit
Hunter-New England Area Health Service
ext: 53358 p: +61 02 498 53358 m: 0413 800 242
KNOTT, Brian brian.kn...@suncorp.com.au 16/04/2010 11:24 am
Scott,
Have a look in the mail error log. It will tell you why what emails
are failing and why. You
, and that it is actually turned on to log
in the CF Administrator.
Brian
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of
Scott Thornton
Sent: Friday, 16 April 2010 11:34 AM
To: 'cfaussie@googlegroups.com'
Subject: RE: [cfaussie] cfmamil
/ don't
work,. any posts on this site about cfajax are quite old
Kym Kovan dev-li...@mbcomms.net.au 23/03/2010 12:19 pm
On 23/03/2010 12:05, Scott Thornton wrote:
Hello,
I have been very lazy and not delved into any ajax stuff, mostly because
I don't have the time, and we have tried to keep
examples, as is Dodo and moo tools.
On Thu, Apr 1, 2010 at 1:26 PM, Scott Thornton
scott.thorn...@hnehealth.nsw.gov.au wrote:
Hello,
Checked out that page, and thought i'd look for examples before I
downaloded to see what it can do etc
http://ajaxcfc.com/
www.ajaxcfc.com etc don't work
template and in an
email that is sent.
Can any recall seeing this too? and point me in the right direction? I thought
i saw it at barneyblog or the one by andy jarret but no luck...
cf 9 development system, cfmx6.1 in live environment.
Scott Thornton, Centralised Billing Unit
Hunter-New England
.
There is no parameters in the above statements.
Steve Onnis st...@cfcentral.com.au 25/03/2010 9:52 am
If you use the result argument and dump that you will get the params
cfquery name=bla result=result
cfdump var=#result# /
-Original Message-
From: Scott Thornton [mailto:scott.thorn
Hello,
I have been very lazy and not delved into any ajax stuff, mostly because I
don't have the time, and we have tried to keep the application I work on as
simple as possible.
However, I was wondering if it was possible to perform the following
asynchronously without a page submit:
User
Hi,
What's the name of the PMS? and who do you work for if you don't mind me asking?
being in health myself... and doing cf, didn't think there where many
people out there like us
Scott Thornton, Centralised Billing Unit
Hunter-New England Area Health Service
ext: 53358 p: +61 02 498
I like Fusionreaactor's ability to kill off processes.. I don't think that is
built into 8 or 9.
BarryC barrychester...@gmail.com 09/02/2010 9:24 am
Hi All
we are looking at getting FusionReactor, but will be upgrading from
Coldfusion 7 to Coldfusion 8 in several months.
How does
Hello,
I am having a bit of a play around with CF9 and CFREPORT
I can successfully display a report based on a datasource and supply a
password, but the resulting output is in .html and a 3 page report scrolls down
the page and looks ugly.
Can I specify the format to be in .pdf? I have tried
hello,
Does anyone know if the new cf9 monitor can be used to kill off slow running
pages\threads? Or is an external product like FusionRector still required?
Thanks,
Scott Thornton, Centralised Billing Unit
Hunter-New England Area Health Service
ext: 53358 p: +61 02 498 53358 m: 0413 800
Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On
Behalf Of Scott Thornton
Sent: Wednesday, December 09, 2009 6:04 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Killing Slow Threads in cf9
hello,
Does anyone know if the new cf9 monitor can be used
sql 2000, 2005 etc
set dateformat dmy
select
from
group by
convert(datetime, convert(varchar, my_date, 103)),
description,
user
or
select
from
group by
year( my_date ),
month(my_date),
day(my_date),
description,
user
PS. either my email client is showing
Hi,
Just checking if cfaussie is still working for me.
Please ignore.
Scott Thornton, Programmer
Billing Unit, Hunter-New England Area Health Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242
--~--~-~--~~~---~--~~
You received this message because you
Hi,
I think Crystal reports is a powerful tool without any real competitors. It
works great on stored proc, views and linked table.. and I don't know how
people really develop 'reports' without it.. I think we have over 300 or so on
the application I work on..
we just found the set-up
Correction... easy to use, a pain to set up...
Steve Onnis [EMAIL PROTECTED] 26/11/2008 3:01 pm
Crystal is a pain to use. Looking for something easy to set up and manage.
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, 26
Hi,
Given a string like acb123, is there a simple method of parsing into the text
portion and the numeric portion.
I have thought about looping of each character of the string and checking to
see if it was IsNumeric.
Any better ideas?
Scott Thornton, Programmer
Billing Unit, Hunter-New
[mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Friday, 21 November 2008 11:03 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] parsing as string into a text and numeric portion
Hi,
Given a string like acb123, is there a simple method of parsing into the
text portion and the numeric
Hi,
I realise it will be of no use whatsoever, but staff here recently replaced a
verity search site ( written in part by myself many many years ago) with a
solution from google.
To be fair the verity solution was only slapped together solution, but the
google result seem more accurate and
Hi,
Out of curiosity, is there expected to be any new releases etc of coldfusion in
the next year? I am trying to decide weather to purchase the maintenance plan
with a some new licences...
Cheers,
Scott Thornton, Programmer
Billing Unit, Hunter-New England Area Health Service
ext: 51762 p
will be released inside of 12 months I think.
Regards
Dale Fraser
http://learncf.com
http://flexcf.com
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Scott Thornton
Sent: Thursday, 30 October 2008 10:54 AM
To: cfaussie
HI,
What's the best place to purchase 2 copies of CF Enterprise these days? From
Adobe direct or an Aussie re-seller? Bear in mind that purchasing by Credit
card is an absolute hassle in an organisation like mine..
Pretty sure we have gone through Daemon before, but its been years ( still
Hi,
I really hate our iframe-based doctor selector thingamy.
I was wondering if dhtml/ajax etc has advanced enough over the years to do a
client-side select as you type select box yet?
What I mean is, is it possible to cache ( or something ) say a list over 2000
items on the client side, and
nvm.
found http://bassistance.de/jquery-plugins/jquery-plugin-autocomplete/
Scott Thornton [EMAIL PROTECTED] 22/10/2008 3:20 pm
Hi,
I really hate our iframe-based doctor selector thingamy.
I was wondering if dhtml/ajax etc has advanced enough over the years to do a
client-side select
redundant server? You may like to check out the terms
Replication and Log Shipping for making hot-standby by copies of your
database. Also clustering sql server for the ultimate in redundancy.
Scott Thornton, Programmer
Billing Unit, Hunter-New England Area Health Service
ext: 51762 p: +61 02 491
cost effective solution may be log shipping.. if you have another
server handy. That may mean you have to point your DSN to the different server
if things go pear-shaped. You could even try catch a specific database error
code and change your DSN in a variable..
Scott Thornton, Programmer
clustering CF next just need
someone to pay for CF licences.
Barry Beattie [EMAIL PROTECTED] 13/10/2008 10:38 am
@Scott Thornton
Also clustering sql server for the ultimate in redundancy.
if someone was after hot-swapping from a primary to a back-up machine,
would clustering those two
PROTECTED] On Behalf
Of Scott Thornton
Sent: Monday, 13 October 2008 11:24 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] OT : SQL server over a network
HI,
Its always worth it ( imho ).
A year or more ago we went from an aging dual-core machine as our SQL server
to a dual quad-core SQL 2005
Hi,
Having had no experience in AIR (or really know what it is), out of curiosity I
installed AIR, and i think installed your app properly.
At first I thought I must be doing something wrong...I didn't see anything
load, then found a little sun on my taskbar, but no program on either of my two
Hi,
Hope you get some great answers. I need to do this myself with a few other
developers here.
Version control as you have found, is as much about the process of using it as
it is as having a repository. It is the process part that undoes me.
Matthew [EMAIL PROTECTED] 26/09/2008 9:25 am
Hi
Before reading .csv files, I typically try to find and replace any repeating
delimiters because as you discovered, CF ( for me its 6.1 ) treats them as one
delimiter and not two.
eg replace two commas with the string comma space comma.
cfset CSV_DATA_LINE = replace(CSV_DATA_LINE, ,,, , ,,
Hi,
to remove the time from a date column I would use (SQL 2000\2005 ETC)
SET DATEFORMAT DMT
SELECT
CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103))
FROM
XXX
GROUP BY
CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103))
On 03/09/2008 at 5:58 pm, in message
).
2. If they type a date like 010101 to automatically parse it out to 01-Jan-2001
3. If the user enters t, enter todays date, if the enter t+1, todays date plus
one, y = yesterday's date and so on.
Cheers,
Scott Thornton, Programmer
Billing Unit
Hunter-New England Area Health Service
ext: 51762
JOIN body_diary_entries bde
ON bd.bdi_id = bde.bdi_id and
entry_date #CreateODBCDate( todays_date )#
Scott Thornton, Programmer
Billing Unit
Hunter-New England Area Health Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242
Seona Bellamy [EMAIL PROTECTED] 22/08/2008 11:54 am
Hi
for the suggestion, Scott. I must admit, I hadn't thought about
putting the date restriction into a join clause. Another trick to add
to my arsenal. :)
Cheers,
Seona.
2008/8/25 Scott Thornton [EMAIL PROTECTED]:
Hi Seona,
I like to use a LEFT OUTER JOIN for a query like this. It would look
Hi,
I just want to stop crazy people inputting junk and causing cf\sql errors.
For this specific case though I am allowing users to search on a monetary
amount, but want to remove the currency formatting from user input ( yes I
guess LSParseCurrency will do this) but also remove at this same
-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Wednesday, 9 July 2008 2:17 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] ReReplaceNoCase - return only a decimal number
Hi,
I would like to create an expression to remove all text and special
Hi,
I would like to create an expression to remove all text and special characters
from a string, returning only a decimal-like looking number..
eg
$12,345.00 - 12345.00
$+10.65 - 10.65
$-5.65 = -5.65
etc
I suck at regular expressions
Cheers,
Scott Thornton, Programmer
Billing Unit
Hi,
Thanks for your email.
No I haven't tried that.. because it doesn't fix typos eg
#LSParseCurrency('$a1234,56.50')# returns a Cf error.
Zac Spitzer [EMAIL PROTECTED] 09/07/2008 2:21 pm
did you try using LSParseCurrency ?
On Wed, Jul 9, 2008 at 2:16 PM, Scott Thornton
[EMAIL PROTECTED
Hi,
Trying to write a little Javascript to validate a field.
I want to have the field contain numeric info only.
My script
var re = new RegExp(^\d+$);
if( field_value.match( re ) )
{
alert('True: does not
nevermind.
I should have used
var re = new RegExp(/^\d+$/);
Scott Thornton [EMAIL PROTECTED] 10/06/2008 2:40 pm
Hi,
Trying to write a little Javascript to validate a field.
I want to have the field contain numeric info only.
My script
var re = new RegExp(^\d
Works fine for me. 2.0.0.11
KC Kuok [EMAIL PROTECTED] 02/06/2008 9:44 am
Just wondering whether anyone else can open in Firefox the MS support
website?
http://support.microsoft.com/
I can't seem to get it open in Firefox, only in IE... Any ideas/
constructive comments?
1 - 100 of 257 matches
Mail list logo
