[cfaussie] RE: Suggestions - CF form security
What is wrong with using cfqueryparam and either htmlEditFormat() or a strip-tags UDF? I'd be interested to see a case these two techniques do not handle. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Tilbrook Sent: Wednesday, 26 October 2005 11:46 p.m. To: CFAussie Mailing List Subject: [cfaussie] Suggestions - CF form security What is the best way to prevent users in a BB type scenario from posting script or SQL into a textfield or textarea? Making changes to the administrator is not an option. I figured there must be something better than REreplaceNoCase. However, if REreplaceNoCase is the best option, does anyone have a readymade snippet of code that will encompass the most malicious tags, SQL attacks, etc? This is a message from a NG and I was stumped apart from using CFQUERYPARAM or UDF's. Any other suggestions? If it is any consolation no-one yet seems to have a safe answer and their have been a few. Thanks! PT --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: quick survey: building *all* the UI with CFcustom tags?
I'm doing this for a site I'm about to launch. For this site, where
different sections (views) are basically modules plugged together in
different ways, it's been great. As well as regular box-like containers,
I have column containers. The big advantage is that you can look at the
markup for the view and visualise what the resulting page with look
like. E.g.
layout:columns
layout:column
layout:box title=asdasd
block:mycontent/
/layout:box
layout:box title=qwert
block:mycontent/
/layout:box
/layout:column
layout:column
layout:box title=zxcvb
block:displayListings recordSet=#records#/
/layout:box
/layout:column
/layout:columns
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Barry
Beattie
Sent: Monday, 26 September 2005 4:16 p.m.
To: CFAussie Mailing List
Subject: [cfaussie] quick survey: building *all* the UI with CFcustom
tags?
Hi all
just curious to see how popular the idea is to totally build the View
layer using CFIMPORT and custom tags.
from page layout all the way down to writing a custom tag wrapper to
HTML controls (and hiding JS behaviour inside them)
Is this a popular thing to do or are ppl still writing basically HTML
pages and injecting CF variables within that?
I just want to see if it's a worthy topic for a CFUG meet and gauge some
idea if others have been doing this also.
thanx
barry.b
Here's what I mean about taking it to the N'th degree with custom
tag-based layout (this is after data has been obtained at the top of the
CFM page)
cfimport prefix=container taglib=../containers cfimport
prefix=control taglib=../controls cfimport prefix=content
taglib=.
container:page class=info text=Records Setup
onload=#onloadEvent#windowLoaded();document.getElementById('tab1').focu
s();
security=#setupPerms#
container:window /
container:header image=../images/mod_titles/setup.gif
container:banner text=Setup left=-6 displayName=
/
container:searchbar title=Accounts Payable Setup /
control:newentitybutton
link=
click=window.location.href =
'setup.cfm?mode=edit';
return false;
image=../images/p_toolbar/edit.gif
text=Edit
security=#editSetup#
/
/container:header
container:form name=entry method=post
action=#cgi.script_name#?batch_ID=#batch_ID#
container:tab id=content1
content:t_accountspayable_setup_parms
security = #setupPerms#
mode = #apparms_mode#
dataModel=#data#
/
container:formsave
id=content1
security=#setupPerms#
/
/container:tab
/container:form
/container:page
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: archive@mail-archive.com
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: Using val() rather than isNumeric()
I'd write (I'm assuming you want integral quantities too) cfset orderQty = int(val(form.qty)) cfif orderQty lte 0 cfset formError = Quantity value must be greater than zero. /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brett Payne-Rhodes Sent: Monday, 5 September 2005 7:45 p.m. To: CFAussie Mailing List Subject: [cfaussie] Using val() rather than isNumeric() I just thought I would share this with everyone. Another lesson in RTFM! I'm a long time user of the 'val()' fumction but have just become aware of a serious mistake in my use of the function... It doesn't do the same thing as isNumeric(), which is how I've been using it. The problem has only arrisen because I've been using val() to check that I can get a numeric value from a string but then *not* using it in the actual assignment. For example (very simplified): cfset form.qty = 33kg cfif val(form.qty) gt 0 cfset orderQty = form.qty cfselse cfset formError = Quantity value must be greater than zero. /cfif Results in an 'orderQty' value of 33kg, when the intent is for the error message to be generated. The problem is that when I later go to use the orderQty in a calculation the whole thing blows up! But didn't it take a long time to find when I was assuming that cfif val() was protecting my code! I should have been doing: cfif val(form.qty) gt 0 cfset orderQty = val(form.qty) cfselse cfset formError = Quantity value must be greater than zero. /cfif Which would result in an orderQty of 33, which in the circumstances would be acceptable. Or: cfif isNumeric(form.qty) cfset orderQty = form.qty cfselse cfset formError = Quantity value must be greater than zero. /cfif Which would generate the error message. And no I don't know why I'm using val() instead of isNumeric(), perhaps I'm just lazy and couldn't be bothered typing 'isNumeric()' all the time - 'val()' is so much easier... Brett B) -- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au w: www.yoursite.net.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: OT: Mulitple Submits
You can simply do this:
form action=http://msn.com/; onsubmit=var btn =
document.getElementById('btn'); btn.disabled=true; btn.value='Please
wait...'
input type=submit id=btn value=test
/form
However, if you actually need the value of the submit button (e.g. if
you have several different buttons) then you need to be smarter. What
you can do is have two buttons for each: one real button and one hidden
and disabled. When the form submits, you hide the real buttons and show
the disabled ones. It looks like the real ones have become disabled, but
really you're just swapping which one is visible. Demo of this technique
here:
http://www.eswsoftware.com/products/terraform/docs/formats_and_datatypes
/Standard_formats/Submit.cfm?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott
Thornton
Sent: Monday, 5 September 2005 5:00 p.m.
To: CFAussie Mailing List
Subject: [cfaussie] OT: Mulitple Submits
Hi,
I am looking for some code to take a humble submit button, and make it
multiple-submit proof. I have seen it around before, but can't recall
the solution.
Eg, After clicking, the button text changes to Please wait, and
becomes disabled, and the form submits still.
Cheers,
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
Phone RNH +61 2 49236066
Fax +61 2 49236076
[EMAIL PROTECTED]
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: archive@mail-archive.com
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: Screen sizes
That's a good point actually. As people get bigger monitors there's less of a tendency to have things full screen, don't you think? Macs don't even have the concept of the full screen window Our company generally designs for 800, but we design some CMS administration screens for 1024 (but only clients see those and we can tell them what to do). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gavin Cooney Sent: Tuesday, 9 August 2005 5:16 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: Screen sizes i make mine fit 800x600. I was doing full width pages for a long time, but now my preference is 800 wide fixed width (actually 800 - scroll bars = 765px). Because any wider is hard to read i think. Gav On 09/08/05, Mike Kear [EMAIL PROTECTED] wrote: For most projects, I design for 1024 wide, but make sure it degrades gracefully to 800 wide. Anyone still using 640 wide or other smaller sizes has to make their own arrangements. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: Hide XML config files
How about * placing the XML in a folder of its own, * changing the extension to cfm, * and adding an application.cfm to the folder with a cfabort in it ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Friday Boi Sent: Thursday, 21 July 2005 6:20 p.m. To: CFAussie Mailing List Subject: [cfaussie] Hide XML config files Hi All, Just wanted to know how you would hide XML config files on a shared hosting environment? Basically dont want anyone to goto http://url/config.xml and view all the site settings. Thanks in advance Pragnesh Do you Yahoo!? Exclusive 'King Kong' Trailer from the maker of 'The Lord of the Rings' http://au.movies.yahoo.com/promo/king_kong.html --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: Debugging
It's worth noting also that turning debugging on on a production server greatly increases the load, even if you only specify one IP address. It seems like CF Server generates the debugging for everybody then only shows it based on the IP. The result is that the server can be exceedingly unstable. Just something to watch out for. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Monday, 4 July 2005 6:44 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: Debugging I have a similar problem Tom with a lot of the sites I work on. The ones i'm referring to are the ones on our shared servers. I can't turn debugging on at the server, unless everyone has overridden that in their pages, or else I only permit some ip addresses to see debugging. (that's not practical because people have different ip addresses all the time and we'd have to keep changing the list of ips) It's not really a simple answer to have debugging turned on for a shared server. --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: bootstrapping or onServerStart
For a non-technical Windows option, how about putting a shortcut to the app URL in the desktop startup folder and using onApplicationStart? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Thursday, 2 June 2005 7:49 p.m. To: CFAussie Mailing List Subject: [cfaussie] bootstrapping or onServerStart hi all we have some large singleton cfc's in server memory. the first user that hits the app after a cold start-up or a restart usually cops these singletons being wound up. any suggestions on how to get an onServerStart type of event to trigger the wind up? Unfortunatly, onApplicationStart in Application.cfc is still tied to the request so the first page hit still does all the hard work. (this will be for cf7 standard so gateways aren't available...) thanx barry.b --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: bootstrapping or onServerStart
Sorry -- responding to old messages. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Walker Sent: Monday, 27 June 2005 4:19 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: bootstrapping or onServerStart For a non-technical Windows option, how about putting a shortcut to the app URL in the desktop startup folder and using onApplicationStart? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Thursday, 2 June 2005 7:49 p.m. To: CFAussie Mailing List Subject: [cfaussie] bootstrapping or onServerStart hi all we have some large singleton cfc's in server memory. the first user that hits the app after a cold start-up or a restart usually cops these singletons being wound up. any suggestions on how to get an onServerStart type of event to trigger the wind up? Unfortunatly, onApplicationStart in Application.cfc is still tied to the request so the first page hit still does all the hard work. (this will be for cf7 standard so gateways aren't available...) thanx barry.b --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: conditional arguments
Possibly not helpful, but:
cfif structKeyExists(myArgument, organisationName)
cfset OrganisationNameSearch.init(myArgument.organisationName)
cfelse
cfset OrganisationNameSearch.init()
/cfif
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Monday, 13 June 2005 2:52 p.m.
To: CFAussie Mailing List
Subject: [cfaussie] conditional arguments
Just curious if argumentsCollection is the only way to overcome the problem
with passing conditional arguments?
I realize that the following works:
cfscript
myArgument = structNew();
myArgument.organisationName = Shelco;
OrganisationNameSearch = new
( class.asic.message.OrganisationNameRequestMessage ).init(
argumentsCollection = myArgument );
/cfscript
But this does not work
OrganisationNameSearch = new
( class.asic.message.OrganisationNameRequestMessage ).init( iif( 1=1, dE
( organisationName = 'Shelco' ), dE() ) );
OrganisationNameSearch = new
( class.asic.message.OrganisationNameRequestMessage ).init( if( 1=1 )
{organisationName = 'Shelco'} );
Note: 1=1 should be structKeyExists()
Taco Fleur - E-commerce Development Manager
Shelco Searches Services
An Authorised ASIC Information Broker
www.shelco.com.au
Ph: + 61 7 3236 2605
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: archive@mail-archive.com
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: Multiple Tables (newbie question)
I'd suggest normalising some more. Have your clinics table just clinic_id and clinic_name. Add a doctor_clinic table that matches up doctor_ids with clinic_ids. Then you can go... SELECT clinics.clinic_name, Doctors.doctor_name, Locations.address FROM( ( clinics INNER JOIN doctor_clinic ON clinics.clinic_id = doctor_clinic.clinic_id ) INNER JOIN doctor ON doctor_clinic.doctor_id = doctor.doctor_id ) INNER JOIN address ON doctor.doctor_id = address.doctor_id ORDER BY clinics.clinic_name, clinics.clinic_id, Doctors.doctor_name, Doctors.doctor_id, Locations.address -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Tom MacKean Sent: Thursday, 22 April 2004 1:54 p.m. To: CFAussie Mailing List Subject: [cfaussie] Multiple Tables (newbie question) Hi List, I have tried to get my head around this, but failed. Simply, Consider three MS Access tables... * DOCTORS - Fields: Doctor_ID, Doctor_Name * LOCATIONS - Fields: Doctor_ID, Address (each doctor can have more than one address) * CLINICS - Fields: Doctor_ID, Clinic_Name (each doctor can work at more than one clinic) What I want to do is display... Clinic Name 1 Doctor Name 1 - Address 1-1 - Address 1-2 Doctor Name 2 - Address 2-1 - Address 2-2 Clinic Name 2 Doctor Name 1 (same doc different clinic) - Address 1-1 - Address 1-2 Doctor Name 3 - Address 3-1 - Address 3-2 - Address 3-3 ...etc... Any help/suggestions most welcome... Thanks Tom Tom MacKean Copywriter/Designer Phone: (02) 9229 6465 Fax: (02) 9231 6965 Mobile: 0414 312 803 NOTICE: Medical and scientific information provided in print and electronically by Sydney IVF might not be relevant to your own circumstances and should always be discussed with your own doctor before you act on it. This communication is confidential and may contain copyright or otherwise protected information of Sydney IVF Limited or a third party. If you are not the intended recipient of this communication please immediately let us know by reply email or telephone us on +61 2 9221 5964, delete the communication and destroy all copies. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Application Logout
Some info on this page: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/shared11.htm#wp116251 4 Personally, I find it way too much hassle and don't bother. If people choose to set their security that high then that's their problem. Of course it depends what you're developing. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Jeremy Sent: Wednesday, 21 April 2004 3:17 p.m. To: CFAussie Mailing List Subject: [cfaussie] Application Logout Hey, Really quick question. I have an application that logs out people when the browser settings in the security section is set to high. It basically things that every page is a new page with no session. Is there a way to override the settings in the browser? OR a bit of code to put in the Applicaiton.cfm to ignore the security settings of the browser. Jeremy --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Cfimport question
You can use mappings -- probably the best bet. You need to note that mappings are turned into absolute paths when the file is compiled. Clearing the cfclasses folder fixed that. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Friday, 2 April 2004 2:44 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: Cfimport question As far as I am aware you can't use mappings either, just relative paths. Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Mark Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:37 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Cfimport question Hi Steve I'm not certain but I think the cfimport tag actually imports the code at compile time so it can't depend on variables that are assigned at runtime. You're using the application variable #application.SNLCNS#, wouldn't it just be easier to use a coldfusion mapping? Cheers Mark -- Mark Stanton Technical Director Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: OT: javascript refresh window
onresize=window.location.reload() Note that it will fire as soon as you start resizing. Could put load on the server as it will fire over and over. You could use setTimeOut() to delay the reload. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Ricardo Russon Sent: Tuesday, 30 March 2004 4:59 p.m. To: CFAussie Mailing List Subject: [cfaussie] OT: javascript refresh window Hi guys.. Is there a javascript to refresh a page if it has been resized? I am using absolute positioned layers and if the window is resized they are out of alignment, until i hit refresh. Is there any other way around this problem? TIA Ricardo. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: XML
Try splitting the cfhttp URL into URL, port, and path attributes. I have a feeling I've been caught by that. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Friday, 26 March 2004 5:30 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: XML Tried that Garry. I've posted the code blow if anyone wants tosee. cfset variables.XML = '?xml version=1.0 encoding=ISO-8859- 1?!DOCTYPE PORTAL SYSTEM http://127.0.0.1:8090/servlet/media/xml/api/request.dtd;PORTAL TransId=testAUTHLOGIN Username=admin Password=admin//AUTHQUERY RefId=getusernameUSER ObjectKey=u310346FIELD Name=Username/FIELD Name=LastName/FIELD Name=FirstName/FIELD Name=Email/FIELD Name=Groups//USER/QUERY/PORTAL' !--- send http request --- cfhttp method=post url=http://mmis010:8090/servlet/portal/admin/xmlproc; username=admin password=admin cfhttpparam type=formfield name=XML value='#variables.XML#' /cfhttp -Original Message- From: G A R Y C R O U C H [ A I T ] [SMTP:[EMAIL PROTECTED] Sent: Friday, 26 March 2004 15:11 To: CFAussie Mailing List Subject:[cfaussie] Re: XML I've experienced the sae issues trying to submit XML via a form field in CFHTTP, The fix for me was to remove all chars that were not plain text including any carriage returns, tabs etc. Fixed the problem but the result at the other end dint look very nice as one long line. Then the result was never sent to a Human so didn't really matter to me, I think though that to be correct XML the positioning of the tags, indentation are conventions that are to be followed. GC - Original Message - From: KNOTT, Brian [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent: Friday, March 26, 2004 2:54 PM Subject: [cfaussie] Re: XML Sean, I have an done a dump of the page that is used to test portal. From this dump I can get a the form to a submit an XML file via a textarea field using onload(submit()). I can't seem to convert this cfhttp. I have a cfhttp tag with a cfhttpparam tag for the form field but it does not seem to send the correct information. Brian -Original Message- From: Sean A Corfield [SMTP:[EMAIL PROTECTED] Sent: Friday, 26 March 2004 11:55 To: CFAussie Mailing List Subject: [cfaussie] Re: XML On Mar 25, 2004, at 5:01 PM, KNOTT, Brian wrote: Ok Guys I can get CF to create an XML document via the CFXML tag. My question is how do I submit this document to an XML server. The following document will return information on a particular user. Our portal has an XML interface that we can submit an XML document to. I'm just not sure how I go about this. Should I use cfhttp. CFXML creates an XML document which is a structure. Some XML servers actually want simple text, some want the XML as a soapElement. It's really going to depend on the server you are trying to communicate with. CFHTTP should do the job either way - once you know what you're really trying to do... Regards, Sean --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 -- - The contents of this message are the views of the Author and do not necessarily reflect the views of SUNCORP METWAY LTD ABN 66 010 831 722. The content of this e-mail, including attachments is a confidential communication between the Suncorp Metway Group and the intended addressee. Any unauthorised use of the contents is expressly prohibited. If you have received this e-mail in error please contact the sender immediately and then delete the message and any attachment(s). http://www.suncorp.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004
[cfaussie] RE: Single quote issue
Some suggestions: 1) Try cfoutput instead of cfquery so you can see what the generated SQL looks like. 2) Is response an integer data type? If so you don't want the quotes. 3) Try using cfquyeryparam. It makes things like this much easier. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Jason Bayly Sent: Wednesday, 24 March 2004 11:11 a.m. To: CFAussie Mailing List Subject: [cfaussie] Single quote issue Hi Guys/Gals, For some reason my inserts are failing due to single quotes. I though CF automatically escaped them in SQL statements. UPDATE TBL_Poll_Responses SET Response = '#EVALUATE(TRIM(VCurResponse))#' WHERE response_id = #EVALUATE(VCurPK)# I need to set my vars dyanmically as im building a quiz app (with many variables), so i need to use the evaluate the function.. Would this be causing my DB errors? (Line 2: Incorrect syntax near '2'.) etc.. Any thoughts? Jason --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Padding text strings
Or I think lJustify() -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Lindsay Evans Sent: Thursday, 18 March 2004 11:57 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: Padding text strings [EMAIL PROTECTED] wrote: Presently I'm doing a len on the data and then using cfloop to add X spaces. Is there a better method. Use RepeatString() instead of cfloop -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness
To me, if there's a point on the road where a lot of crashes occur, then that's bad design, as the designers clearly haven't considered real human behaviour. The same logic applies to software: if something trips a lot of users up, there's no point saying users are stupid. You fix the problem. However, as systems increase in power, they necessarily become more complicated. That tradeoff is everywhere, e.g. in manual vs automatic cars. The goal is to identify on the curve where your audience lies and design for that balance of power/ease of use. In order to keep everybody happy, it may be possible to present different interfaces for different levels of user. Windows does this, Dreamweaver does this, decent autofocus cameras do this, the new Minis do, and the CMS's in the subject line AFAIK do this. It's a common solution. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Scott Barnes Sent: Wednesday, 17 March 2004 12:40 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness On the train ride in this morning i noticed one thing to sum up general people stupidity. I looked out my window and noticed a 2 car pile-up just up from an off-ramp to the main highway. Now heres a very simple example of how we humans just don't think. Concept: If you see an on-ramp ahead, that cars utilise to GET on the highway, it makes perfect sense that in order to allow these new objects to merge with the mainstream flow, one would move into another lane (or multiple lanes if you will). YET.. There is always a cluster of clowns who just don't get it and end up plowing into the car thats trying to merge. (Truck nearly did this to me yesterday aswell). Simple procedure, totally [EMAIL PROTECTED])ked up by a user. Point: You can only hand hold so much before you just need to start doing random beatings. -- Regards, Scott Barnes - http://www.mossyblog.com http://www.bestrates.com.au CFAussie wrote: Further to this, and also from a commercial perspective.. We've developed an app called Sitewizard (www.sitewizard.com.au) that is aimed at novice users who want to get a hosted Web site in minutes using a pre-defined template and packaged features.. Now, we set out to make it very easy to use -- big icons, big text, lots of help options, etc etc.. A lot of people have commented about how easy it is to use. But there are also those who still don't get it, and still need to have their hand held. My point is that it is impossible to build an interface for a CMS, even a very simple CMS, that *everyone* will get. I don't even know if focus testing for two months or getting Donald Norman in as a consultant would help. Darryl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Barnes Posted At: Tuesday, 16 March 2004 4:03 PM Posted To: CFAussie Conversation: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness Subject: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness Dude, I've busted my ass a couple of years ago writing a CMS for a few govt depts for a company called Urban Media. We spent more time making the UI then we did the architecture behind it, it was pretty sexy in regards to feedback and what not (i dazzled the monkeys with progress bars, funky dhtml/flash combinations etc - those who saw it can confirm/deny its ease of use aswell). Despite it being very simple to use it wasn't as mature (enterprise level) as Shado or FarCry, but it allowed them to run sites via a simple approach (pretty much contribute kinda simple with dynamics) (ie no DMS or high-tech backup stuff etc). Having said that, it still wasn't enough. The UI was still not clear enough for monkeys who can't even install Office let alone run a website? and in truth applications like DreamWeaver (which is very simple for most) is a failure in that regard as well (just look at all the self-help books around). Point is, you can only automate a solution so far before the gloves come off and you have to start digging with your bare hands. This is where the developer comes into play. One can argue think outside the box all they like, but if you manage to formulate a balance between Server-Side CMS and Client-Side CMS solutions, then you are years ahead of solutions such as Shado/FarCry/Common Spot etc CMS by nature are solutions put in place to formulate the web development process, to allow the abstract thinking to take care of itself and make it a straight forward solution (backups, auto-archiving, auto-search engine seeding, auto-search-indexing etc). The biggest problem and annoyance is a lot of software keyturn solution makers, have spun the CMS for Dummies tune way too much, which in return, raises everyones expectations on
[cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness
Perhaps the bottom line is that the product must be deployed to a CF server. Designers and general office workers are not qualified to place an application on a server, or in most cases have any degree of FTP access. Therefore, a developer is required. An alternative might be a hosted system where one shared app is used by a multitude of sites. This is a common formula in the blogging world, e.g. Blogger and TypePad (but, in contrast, not Movable Type). Off the top of my head, I would say there may well be an opening for an app like this, that could use templates and publish to any regular FTP server. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 16 March 2004 1:58 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness So here we have two brilliant application, and you are saying it is normal that when you sell it or make it available for download it comes with a note saying You need a developer to install and set this application up? When you buy Office it doesn't come with any notice like that, there is an installation and set-up process that helps guide the user through the installation and set-up. OK, these two applications have chosen not to go that way which is their prerogative, but for you to say it is normal I don't agree with.. Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Stephen Milligan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 March 2004 11:48 AM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness If that surprises you then maybe the kind of functionality you require would be found in contribute. That can be installed and configured by just about anyone and it allows non-technical users to manage the content of their website. It is of course severely limited if you want to do things like site searching, automatic navigation, content scheduling, stats tracking and a bunch of other things that come with both Shado and FarCry. It's a bit like being surprised about the expectation of a sysadmin being involved when asking about the difference between DB2 and Oracle. In that case you should probably be using Access. Spike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Monday, March 15, 2004 5:37 PM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness One thing that surprises me when talking about both Content Management Systems, you always assume there are developers involved, and I believe you even rely on this fact for installation and set-up. Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 March 2004 11:38 AM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] CMS Shado vs FarCry - User friendliness Taco Fleur wrote: I actually think your question is too broad when you say user-friendly. When I say non-technical I mean that they are on the level of being able to send an email and no higher than that when it comes to computers. You have a fine balance between sophistication and complexity. It is impossible to offer a lot of features when the user just wants to see one GO button. FarCry offers multiple views of the administration area; some complex some less so. You can readily rewrite admin interfaces to remove unwanted features and further simplify the environment; in the fact the framework is specifically designed to allow developers considerable latitude. You can even expose administrative features in the presentation layer/website proper so users don't have to go to the admin area at all. It's all a question of how simple an interface your audience requires and this is generally a factor of how sophisticated their content management requirements are. User Friendly is actually a factor of a user's training, how often they deal with the system, and what they actually need to do in the system. Someone who only turns up every blue moon to post an article needs something *very* simple, whereas a user who turns up every day to post content (regardless of their initial technical ability) can be taught quite readily to perform much more complex tasks. Thus far I only have received biased response ;-)) Both Shado and FarCry have large audiences of non-technical users working with the products daily. For what it's worth, I'd say they're both very configurable and both more user friendly than the vast majority of CMS products on the market. -- geoff http://www.daemon.com.au/ PS. there is no such thing as an unbiased response
[cfaussie] RE: CFUG NZ
There's a New Zealand MUG list managed by Straker. Email Grant at straker.co.nz. I think there is a post-MXDU meeting planned soon. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Matthew Bryant Sent: Thursday, 4 March 2004 10:19 a.m. To: CFAussie Mailing List Subject: [cfaussie] CFUG NZ I know this is the Aussie List but would anyone happen to know anything about the NZ CFUG? The site seems broke and I would like to turn up to anything if there is something to turn up to ;-) I am in Auckland for another 8 months. Cheers, Mat. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: tracking down unusual record deletions
How exactly is the delete occurring? Did you change a cfquery DELETE to a cfquery UPDATE? If so then clearly this query is being run, right? What does the WHERE clause look like? Its possible from within the web pages for staff to delete records from these 2 tables, so I changed this function from being a real delete to marking the records inactive. When I did this, the problem changed from the records being deleted to being marked inactive. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: tracking down unusual record deletions
Probably a good idea to use cfqueryparam -- cfqueryparam value=#URL.id# cfsqltype=CF_SQL_INTEGER instead of #url.id# Are users logged in? Can you add another column that stores the login id when records are flagged deleted? Or even CGI data? Also it might be worth storing the date/time of deletion. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Susan Murray-Smith Sent: Thursday, 26 February 2004 1:39 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: tracking down unusual record deletions The query statements are: CFQUERY DATASOURCE=Libmag UPDATE tblMeetings SET Active = no WHERE tblMeetings.Meet_ID=#URL.id# /CFQUERY The URL.id comes from the previous page = its a basic display a list and select a single item to edit or delete. Thats why its hard to think why 20+ records would be deleted this way. I am trying to track down the server logs to see if there is any file activity that will point me in the right direction. Thanks for tips! regards susan At 12:23 PM 26/02/2004, you wrote: How exactly is the delete occurring? Did you change a cfquery DELETE to a cfquery UPDATE? If so then clearly this query is being run, right? What does the WHERE clause look like? Its possible from within the web pages for staff to delete records from these 2 tables, so I changed this function from being a real delete to marking the records inactive. When I did this, the problem changed from the records being deleted to being marked inactive. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 Susan Murray-Smith, Web Services Coordinator University of Sydney Library F03 University of Sydney NSW 2006 AUSTRALIA Ph: (612) 9351 3804 Fax: (612) 9351 2890 Email: [EMAIL PROTECTED] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: text area character countdown
Like this? http://www.electricsheep.co.nz/terraform/gallery/test3/index.cfm Feel free to steal the code (it's mine). Matt. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Stuart Kidd Sent: Tuesday, 24 February 2004 4:19 a.m. To: CFAussie Mailing List Subject: [cfaussie] text area character countdown Hi guys, I remember seeing a page once in the past where the textarea had a countdown. I want users to only type in 120 characters but it would be nice for them to see the amount of characters they have left to use dynanically changing. This will be used for text messaging (120 characters for the user and then 40 for a footer). If anyone knows a way of doing this please notify. Thanks, Stuart --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: uploading an existing webpage via coldfusion
There's also a zip custom tag in the latest MACR DRK -- DRK6. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Clifton Steve Sent: Tuesday, 24 February 2004 9:26 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: uploading an existing webpage via coldfusion Rob, You probably need to look at a few things here: 1. Cffile to upload a zip file 2. Cfdirectory to create a new folder to upload the zip file to (if it hasn't been created) 3. CFX_ZIP custom tag to unzip the uploaded zip file to the specified folder on-the-fly. Don't ask me how to do this, cos I have never unzipped files on-the-fly, but as long as the user can zip their site, I don't see any reason why you couldn't unzip it in this way. Good luck. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of rob Sent: Tuesday, 24 February 2004 8:16 AM To: CFAussie Mailing List Subject: [cfaussie] uploading an existing webpage via coldfusion I have a number of teachers looking at uploading their existing .html pages with images into the new coldfusion intranet Is there a way they can just upload the site folder in a form and then i could load it via a pop up window So i guess what i am asking is whether you can upload an entire folder in one simple action?? Thanks people Rob. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Opinions on naming form fields the same as db columns...
Title: Message I agree you cant rely on people not guessing your column names. I call them the same where possible. You can btw write: cfset form[variables.column] = qContact[variables.column] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Thursday, 12 February 2004 2:53 p.m. To: CFAussie Mailing List Subject: [cfaussie] Opinions on naming form fields the same as db columns... I am have been using the same naming convention and names for my DB columns as for my form fields (or vice versa), this allows for simple form population like following cfquery name=qMyQuery datasource.. SELECT blah, blah FROM. /cfquery cfloop index=column list=#qMyQuery.columnList# cfset setVariable(form.#variables.column#, qContact[variables.column]) /cfloop I can already hear people saying but then all crackers know your column names etc. etc. I am aware of this, personally I think this is something not to really worry about, as they can easily be guessed unless you are using some very cryptic names for your columns. Second, if they have come to a point where they could actually do something with those column names it would be just aseasy to get them at that stage. Another advantage is that you never have to mix and match form fields with column names Anyway, what I am looking for is negativity from you guys ;-)) Tell me why I should really not do this... Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Opinions on naming form fields the same as db columns...
Title: Message I think qContact is supposed to be qMyQuery -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Evans Sent: Thursday, 12 February 2004 3:26 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: Opinions on naming form fields the same as db columns... Can someone fill me in on what the qcontact construct is? Thanks, Phil. - Original Message - From: Matthew Walker To: CFAussie Mailing List Sent: Thursday, February 12, 2004 2:12 PM Subject: [cfaussie] RE: Opinions on naming form fields the same as db columns... I agree you cant rely on people not guessing your column names. I call them the same where possible. You can btw write: cfset form[variables.column] = qContact[variables.column] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Thursday, 12 February 2004 2:53 p.m. To: CFAussie Mailing List Subject: [cfaussie] Opinions on naming form fields the same as db columns... I am have been using the same naming convention and names for my DB columns as for my form fields (or vice versa), this allows for simple form population like following cfquery name=qMyQuery datasource.. SELECT blah, blah FROM. /cfquery cfloop index=column list=#qMyQuery.columnList# cfset setVariable(form.#variables.column#, qContact[variables.column]) /cfloop I can already hear people saying but then all crackers know your column names etc. etc. I am aware of this, personally I think this is something not to really worry about, as they can easily be guessed unless you are using some very cryptic names for your columns. Second, if they have come to a point where they could actually do something with those column names it would be just aseasy to get them at that stage. Another advantage is that you never have to mix and match form fields with column names Anyway, what I am looking for is negativity from you guys ;-)) Tell me why I should really not do this... Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Compare - display changes
This looks promising: http://www.ics.uci.edu/~eppstein/161/960229.html
I've been playing around with it. Got to this point (i.e. shows the longest
common subsequence but not the diff markup). Still experimenting
cfset str1 = aquijk borwn fox jumped way over the lazy dog
cfset str2 = The quick brown fox jumped over the lazy dog!
cfset arr1 = listToArray(str1, )
cfset arr2 = listToArray(str2, )
cfset results = arrayNew(2)
cfoutput#lcs_length2(1, 1)#/cfoutput
cfscript
function lcs_length(posInArr1, posInArr2) {
var result = 0;
if ( results[posInArr1][posInArr2] neq -1 )
return results[posInArr1][posInArr2];
if ( (posInArr1 gt arrayLen(arr1)) or (posInArr2 gt
arrayLen(arr2)) )
result = 0;
else
if ( arr1[posInArr1] eq arr2[posInArr2] )
result = 1 + lcs_length(posInArr1+1,
posInArr2+1);
else
result =
max(lcs_length(posInArr1+1,posInArr2), lcs_length(posInArr1,posInArr2+1));
results[posInArr1][posInArr2] = result;
return result;
}
function lcs_length2(posInArr1, posInArr2) {
for ( i = arrayLen(arr1)+1; i gte 1; i=i-1 )
for (j = arrayLen(arr2)+1; j gte 1; j=j-1 ) {
if ( (i gt arrayLen(arr1)) or (j gt arrayLen(arr2))
)
results[i][j] = 0;
else
if ( arr1[i] eq arr2[j] )
results[i][j] = 1 +
results[i+1][j+1];
else
results[i][j] = max(results[i+1][j],
results[i][j+1]);
}
return results[1][1];
}
/cfscript
cfset sequence =
cfset i = 1
cfset j = 1
cfset notDone = true
cfloop condition=#notDone#
cfif arr1[i] eq arr2[j]
cfset sequence = listAppend(sequence, arr1[i], )
cfset i = i + 1
cfset j = j + 1
cfelseif results[i+1][j] gte results[i][j+1]
cfset i = i + 1
cfelse
cfset j = j + 1
/cfif
cfset notDone = ((i lte arrayLen(arr1)) and (j lte
arrayLen(arr2)))
/cfloop
cfoutput#sequence#/cfoutput
-Original Message-
From: [EMAIL PROTECTED] [mailto:bounce-cfaussie-
[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Wednesday, 11 February 2004 12:19 p.m.
To: CFAussie Mailing List
Subject: [cfaussie] RE: Compare - display changes
allright, I have quickly put something together and came up with the
following solution to display modified values from dropdowns, but I still
have no good method to display differences between strings.
I am thinking of performing the compareNoCase on the strings but that
still will only show whether there is a difference, not what is different,
i.e. deleted or added... (I might even use the MS SQL DIFFERENCE keyword
instead and perform this within the db)
I am looking for some input, ideas and better ways... ;-))
Summary: I have an original resultset (unmodified) and a modified
resultset (actually wddx package), I'd like to display to the user what
the differences are in detail (as much detail as possible).
cfset originalList = 1,2,3,4,5,55
cfset modifiedList = 2,5,7
cfscript
function fnListToQuery( columnName, list )
{
var objQuery = queryNew(columnName);
for ( i = 1; i LTE listLen(list); i = i + 1 )
{
queryAddRow(objQuery, 1);
querySetCell(objQuery, id, listGetAt(list, i), i);
}
return objQuery;
}
/cfscript
cfset objQuery = fnListToQuery( id, originalList )
cfset objQuery2 = fnListToQuery( id, modifiedList )
cfquery dbtype=query name=qTest
SELECT *
FROM objQuery
WHERE (id NOT IN(#modifiedList#))
/cfquery
cfquery dbtype=query name=qTest2
SELECT *
FROM objQuery2
WHERE (id NOT IN(#originalList#))
/cfquery
cfoutput
p
cfloop query=qTest
Deleted: #qTest.id#br
/cfloop
cfloop query=qTest2
Added: #qTest2.id#br
/cfloop
/p
I might even do the above within the RDMBS instead of CF.
Taco Fleur
07 3535 5072
Blog: http://www.tacofleur.com/index/blog/
Methodology: http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-Original Message-
From: Mark Stanton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 11 February 2004 9:17 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Compare - display changes
Cheers for the calendar, but I think it was Rob who was after
a calendar ;-))
Sorry too early for my brain to be properly in gear yet :)
Cheers
Mark
--
Mark Stanton
Technical Director
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
[cfaussie] RE: [OT] JS to early or bug?
Yes, it's beside the point. There's nothing wrong with using onclick on an a tag -- you just have to add return false if appropriate. Makes no difference to your situation though. Here, try this: a id=hi href=javascript:alert(this.id);1/a a id=yo href=mylink.cfm onClick=alert(this.id);return false;2/a It seems that in the second case, this refers to the a tag. In the first case it *doesn't refer to the a tag. Perhaps it refers to the JS block? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Monday, 9 February 2004 11:28 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: [OT] JS to early or bug? A a href=... already has an onclick event. You're asking your humble a tag to do two things when you click it - that's generally bad news. __ But isn't that all besides the point? No one has still been able to tell me exactly why a href=# onClick=alert(this); returns 'http://blah.com/page.cfm#' And a href=javascript:alert(this); returns the object Or has anyone explained? I'm doing pretty bad today, mentally and physically, had another nasty run-in with the Aussie sun again, maybe I have a sunstroke? ;-)) --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: [OT] JS RegEx
[^a-z\.,] is not a string of characters. It's a class, which will match exactly one character in that class. [^a-z\.,]+ is a string of characters. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Monday, 1 December 2003 10:39 a.m. To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] JS RegEx Hi Graham, not sure if your regex would work, but I do know it would not work for me, as the regex string is not just one character but a long string of characters like [^a-z\.,] etc. so I would not be able to specify the backreference. example obj.value = obj.value.replace([^a-z\.,'\-\s], ); -Original Message- From: Graham Cook [mailto:[EMAIL PROTECTED] Sent: Friday, 28 November 2003 11:42 PM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] JS RegEx Hi Taco, I'm a newbie at regular expressions, but looking at my O'Reilly book they give the example to remove any doubled words: cfset NoDupes = ReReplaceNoCase(I would like to go to to the park,([A- Z]+)[ ]+\1,\1,\1,ALL From that could the extrapolation for your situation be along the lines: ([']+)[]+\1,\1,\1,ALL Regards Graham Cook --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: [OT] JS RegEx
Just trying to help. If you understood what a cass was then you'd understand
why you can't put {} in it. A little politeness wouldn't hurt.
-Original Message-
From: [EMAIL PROTECTED] [mailto:bounce-cfaussie-
[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Monday, 1 December 2003 10:48 a.m.
To: CFAussie Mailing List
Subject: [cfaussie] Re: [OT] JS RegEx
whatever, just close this discussion, its getting nowhere..
Whether that is because I am not explaining myself well enough, or whether
the discussion is not followed from the first email I do not know.
I am giving up on this one.
Thanks all..
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Monday, 1 December 2003 8:44 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: [OT] JS RegEx
[^a-z\.,] is not a string of characters. It's a class, which will match
exactly one character in that class.
[^a-z\.,]+ is a string of characters.
-Original Message-
From: [EMAIL PROTECTED] [mailto:bounce-cfaussie-
[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Monday, 1 December 2003 10:39 a.m.
To: CFAussie Mailing List
Subject: [cfaussie] Re: [OT] JS RegEx
Hi Graham,
not sure if your regex would work, but I do know it would not work for
me,
as the regex string is not just one character but a long string of
characters like [^a-z\.,] etc. so I would not be able to specify the
backreference.
example
obj.value = obj.value.replace([^a-z\.,'\-\s], );
-Original Message-
From: Graham Cook [mailto:[EMAIL PROTECTED]
Sent: Friday, 28 November 2003 11:42 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: [OT] JS RegEx
Hi Taco, I'm a newbie at regular expressions, but looking at my O'Reilly
book they give the example to remove any doubled words:
cfset NoDupes = ReReplaceNoCase(I would like to go to to the
park,([A-
Z]+)[ ]+\1,\1,\1,ALL
From that could the extrapolation for your situation be along the
lines:
([']+)[]+\1,\1,\1,ALL
Regards
Graham Cook
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to leave-cfaussie-
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to leave-cfaussie-
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to leave-cfaussie-
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to leave-cfaussie-
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: get primary key allocated during insert?
Which DBMS are you using? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Brian Gilbert Sent: Wednesday, 26 November 2003 11:12 a.m. To: CFAussie Mailing List Subject: [cfaussie] get primary key allocated during insert? Hi all, Is there a way to get the primary key (autonumber) that would be allocated during an insert statement in a cfquery? TIA Brian --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: get primary key allocated during insert?
Sorry -- ignore me. Inadvertently responding to old messages. ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Matthew Walker Sent: Thursday, 27 November 2003 10:07 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: get primary key allocated during insert? Which DBMS are you using? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Brian Gilbert Sent: Wednesday, 26 November 2003 11:12 a.m. To: CFAussie Mailing List Subject: [cfaussie] get primary key allocated during insert? Hi all, Is there a way to get the primary key (autonumber) that would be allocated during an insert statement in a cfquery? TIA Brian --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: CFLOCK
Title: CFLOCK Well, actually no. With CFMX you only need to lock to prevent race conditions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Tuesday, 25 November 2003 11:47 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: CFLOCK YES YES YES Always lock -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur Sent: Tuesday, November 25, 2003 10:39 AM To: CFAussie Mailing List Subject: [cfaussie] CFLOCK I have followed a few discussions on this subject, but all are contradicting each other or say it's recommended to lock, I was wondering if anyone could give a firm answer on the following. Do we still need to lock application, server and session variables in CFMX? YES/NO Until recently I set all my application variables like DSN, mappings etc. in the REQUEST scope, so they are available to TAGS and CFCs and whatever. If I ever worked with the SESSION or APPLICATION scope I always made the scope local before I worked with it, like so cflock timeout=10 throwontimeout=yes type=readonly scope=application cfset setting = duplicate(application.setting) /cflock But for any vars that govern the application this is not possible, because it would mean the variables would not be available to all TAGS and CFCs etc. So I had to lock any call to the vars in TAGS etc. if I wanted to use those scopes, which gets a bit annoying in the end.. The REQUEST scope works fine, but it means on every request all the vars get set again, and if I don't need to lock the APPLICATION scope anymore it might be time to move that way./ TIA Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: query of query functions
The function is upper() -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Toby Tremayne Sent: Thursday, 20 November 2003 1:30 p.m. To: CFAussie Mailing List Subject: [cfaussie] query of query functions Hi All, when you're doing a QoQ, is there anyway to upper case something you're checking against? For instance in sql server I'd do this: where UPPER(status) = '#uCase(myVar)#' but I can't find an equivalent for QoQ - am I just stuck? cheers, Toby Life is Poetry, write it in your own words Toby Tremayne Cold Fusion Developer Code Poet and Zen Master of the Heavy Sleep Virtual Tours +61 416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: CFMX wddx error
With all due respect Rod, I think without the wddx packet you will be talking to yourself. Can you remove bits from the packet until the error disappears? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Tuesday, 11 November 2003 1:18 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: CFMX wddx error I just loaded the wddx file into xmlspy and then assigned the lastest wddx dtd wddx_0100.dtd from openwddx.org. I then checked the well-formedness and then validated the file and it checked out fine. So can some one please tell me what is going on? By the way the CFMX version is 6.1. Seems there is a very annoying bug with the production release. Can anyone confirm this? I cant see why a well-formed and validate wddx packet is causing an error when trying to be parsed by cfwwdx on CFMX??? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: CFMX wddx error
Can you remove bits from the packet until the error disappears? Why should I have to? If the file is well formed and validate it should parse correctly. The purpose of wddx is an open source standard to transfer data. If I have to modify parts of the file generated by an external system that conforms to the lastest wddx dtd doesn't that seem to work against what wddx is trying to achieve? When I get an error I usually try removing bits until the error goes away, then I know the last bit I removed was the problem. Sometimes it's relevant advice, sometimes not. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: CFMX wddx error
When I run this code: cfwddx action=WDDX2CFML input=#packet# output=data validate=yes cfdump var=#data# on that WDDX packet, it works fine for me. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Tuesday, 11 November 2003 2:20 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: CFMX wddx error Have you tried changing the version number of the packet as suggested?? -- geoff http://www.daemon.com.au/ CFMX generates wddx packets with the same version number 1.0 as per CFMX. I did notice that CFMX adds a value for the type attribute in the recordset element with the value of coldfusion.sql.QueryTable. Not to sure if this mattered so I added this to some sample data and it generated the same error. Just about to give up on this one --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 2:24 p.m. To: CFAussie Mailing List Subject: [cfaussie] RegEx.. I have this RegEx cfset regEx = \s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d* It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like , Lamington National Park Road , Lamington National Park Road , I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: CFMX wddx error
Yes, 6.1. That's with your packet wrapped in cfsavecontent variable=packet/cfsavecontent all in the same cfm file. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Tuesday, 11 November 2003 2:48 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: CFMX wddx error When I run this code:=20 cfwddx action=3DWDDX2CFML input=3D#packet# output=3Ddata = validate=3Dyes cfdump var=3D#data# on that WDDX packet, it works fine for me.=20 What version of cfmx are you running? 6.1? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 4:04 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like Level 2, 55 Harrington Street, LEVEL 17, 175 EAGLE ST, Level 2, 38 York Street -Original Message- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 1:46 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. What does an original string look like? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur Sent: Tuesday, November 11, 2003 2:20 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. I loop over 13.000 records... yeah I know, but how in godsname do you do a regex in MS SQL? I haven't found how yet, if there is a HOW Maybe it could be done by working with SPs and call some objects, but I haven't figured out how yet... ;-)) -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 1:01 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. Are you applying the regex to lots of strings like , 55 Harrington Street or to one big string with lots of entries? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 2:53 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. Nope, I still get entries like , 55 Harrington Street , 80 William St 1 Eagle Street, I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 12:34 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 2:24 p.m. To: CFAussie Mailing List Subject: [cfaussie] RegEx.. I have this RegEx cfset regEx = \s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d* It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like , Lamington National Park Road , Lamington National Park Road , I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February
[cfaussie] RE: RegEx..............
Title: RegEx.. Try adding ,all to your rereplace parameters. Default behaviour is just one replacement. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 4:58 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. cfsetting requesttimeout=800 cfquery name=qOrganisation datasource=dsnCCDB_testing SELECT[Street Address 1] AS addressline1, TempID FROM_temp_All_Datasources_Deduped WHERE(NOT ([Street Address 1] IS NULL)) AND (levelFloor IS NULL) ORDER BY [Street Address 1] /cfquery cfset regEx = \s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d* cfloop query=qOrganisation cfset found = refindNocase(variables.regEx, qOrganisation.Addressline1, 1, true) !--- a bit messy --- cfset address = trim(reReplaceNoCase(qOrganisation.Addressline1, variables.regEx, )) cfset address = trim(reReplaceNoCase(trim(variables.address), (^[[:space:],]+|[[:space:],]+$), )) cftry cfquery name=qInsert datasource=dsnCCDB_testing UPDATE_temp_All_Datasources_Deduped SETlevelFloor = '#lcase(trim(mid(qOrganisation.Addressline1, found.pos[1], found.len[1])))#', streetAddress1Copy = '#variables.address#' WHERE(TempID = #qOrganisation.TempID#) /cfquery cfcatch/cfcatch /cftry /cfloop --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Regular Expressions.
This is actually very difficult unless you are using CFMX, which supplies non-greedy matching. Assuming you are not using CFMX, we have to make a rule that there will be no ] in your URL or URL name. Square brackets have meaning in regexes so we escape them with a \. Parentheses () capture the URL and the URL name. Later we use back references \1 and \2 to refer to them. [^]]* is a character class. A class is anything wrapped in square brackets. The * means match none or more of this class, but as many as possible. ^ means match everything that is not in the following set of characters, i.e. match everything but a closing square bracket. So the character class is anything but ]. This might have errors: reReplaceNoCase(myString, \[URL\]([^]]*)\[/URLNAME\]([^]]*)\[/URL\], a href=\1\2/a, all) Matt. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Gareth Edwards Sent: Friday, 7 November 2003 12:41 a.m. To: CFAussie Mailing List Subject: [cfaussie] Regular Expressions. Just wondering if anyone is any good with regular expressions, cos I am yet to learn them. Can someone help me with the following using Regular Expressions. I've looked on CFLIB and there are some handy conversions but not quite the one I require. [URL]Insert Address here[/URLNAME]Insert name here[/URL] to replace it with the relivent href link. I also need to reverse the process.. so I may return the [] names rather than the href link. So all the actually html stays hidden. Cheers Gareth. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: weird javascript behaviour
Are you sure the problem is here? Looks OK to me. What happens if you view update_all_student_browse.cfm?year=-2 ? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Ben Yee Sent: Friday, 7 November 2003 11:30 a.m. To: CFAussie Mailing List Subject: [cfaussie] weird javascript behaviour Hey All, I've got this line of javascript var year = 05; document.all.menuloader.src = update_all_student_browse.cfm?year=+year; which works fine when the year is a positive number, however when the year becomes a negative (eg year = -2) I get a syntax error. I've tried URL Encoding it but it still does not work. any suggestions thanks ben --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: weird javascript behaviour
OK so you can view the page update_all_student_browse.cfm?year=-2 in your browser and you get an error? That means your JS is OK. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Ben Yee Sent: Friday, 7 November 2003 11:41 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: weird javascript behaviour mat, Yeah I've tried that and the same thing happens. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Friday, 7 November 2003 9:38 AM To: CFAussie Mailing List Subject: [cfaussie] RE: weird javascript behaviour Are you sure the problem is here? Looks OK to me. What happens if you view update_all_student_browse.cfm?year=-2 ? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Ben Yee Sent: Friday, 7 November 2003 11:30 a.m. To: CFAussie Mailing List Subject: [cfaussie] weird javascript behaviour Hey All, I've got this line of javascript var year = 05; document.all.menuloader.src = update_all_student_browse.cfm?year=+year; which works fine when the year is a positive number, however when the year becomes a negative (eg year = -2) I get a syntax error. I've tried URL Encoding it but it still does not work. any suggestions thanks ben --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: Voice Transcription to Text
Well it needs to be client side as you couldn't really send all that data around. I played with Microsoft Agent a few years ago which is free and more or less does this. Probably not very well... -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Phil Evans Sent: Thursday, 6 November 2003 10:00 a.m. To: CFAussie Mailing List Subject: [cfaussie] Voice Transcription to Text Hi All, I have a client inquiring about whether he can use voice recognition software to enter comments / notes into an internet site. I know there is plenty of client based software that could achieve this. I'm just wondering if anyone had come across an internet based solution, so that all the user needs is a microphone and the web site will transcribe the text equivalent. Thanks, Phil. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] cfrmx script to enable a dsn
We are having a problem with DSNs spontaneously disabling themselves. Aside from getting that problem fixed, I was wondering if there was a way to re-enable a dsn thru script. I've been exploring the factory.getDataSourceService() but haven't got far. Anybody have any experience with this? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: cfrmx script to enable a dsn
Sure there is. Under advanced: Disable Connections -- Suspend all client connections. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 6 November 2003 11:22 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: cfrmx script to enable a dsn How is it disabled? there is no Enabled/Disabled state for a DSN Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Walker Sent: Thursday, November 06, 2003 10:17 AM To: CFAussie Mailing List Subject: [cfaussie] cfrmx script to enable a dsn We are having a problem with DSNs spontaneously disabling themselves. Aside from getting that problem fixed, I was wondering if there was a way to re-enable a dsn thru script. I've been exploring the factory.getDataSourceService() but haven't got far. Anybody have any experience with this? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: cfrmx script to enable a dsn
Yes, checked, and fails verification. The error reads: java.sql.SQLException: Establishing database connection is currently disabled. It's just as if someone has gone in and checked that box. Only no one has done that. I'm pretty sure we don't have any disgruntled employees. ;-) But it only happens on certain datasources (this is a multi-homed server with perhaps 20 sites) -- one on a regular basis. We have tried creating a new DSN for this one. We'll see how that goes. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Beattie, Barry Sent: Thursday, 6 November 2003 11:31 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: cfrmx script to enable a dsn does it actually show up as disabled (checkbox) OR if you verify the datasources, most of them error? and you get page errors about JDBC connection issues? cheers barry.b -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, 6 November 2003 9:29 AM To: CFAussie Mailing List Subject: [cfaussie] RE: cfrmx script to enable a dsn Sure there is. Under advanced: Disable Connections -- Suspend all client connections. -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 6 November 2003 11:22 a.m. To: CFAussie Mailing List Subject: [cfaussie] RE: cfrmx script to enable a dsn How is it disabled? there is no Enabled/Disabled state for a DSN Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Walker Sent: Thursday, November 06, 2003 10:17 AM To: CFAussie Mailing List Subject: [cfaussie] cfrmx script to enable a dsn We are having a problem with DSNs spontaneously disabling themselves. Aside from getting that problem fixed, I was wondering if there was a way to re-enable a dsn thru script. I've been exploring the factory.getDataSourceService() but haven't got far. Anybody have any experience with this? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: cffile Java.IO.FilePermision Error
What are you actually doing with cffile? Upload? And does that temp file exist? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Nick Gorst Sent: Thursday, 6 November 2003 11:57 a.m. To: CFAussie Mailing List Subject: [cfaussie] cffile Java.IO.FilePermision Error Hi I get the following error when trying to use CFFILE in CFMX access denied (java.io.FilePermission C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot- tmp\neotmp20763.tmp read) null brThe error occurred on line -1. I have allowed CFFILE, I have setup Sandbox security to allow writing to the directory, I have set up the directory permisions to allow web users to write to the directory. Is there something blindingly obvious missing here or do I need to start fine tuning the system with an axe :) Has anyone encountered this before? I've tried getting info from Macromedia Forums but can't find what I'm looking for (Or I'm looking for all the wrong things) I also did a search back over my cfaussie emails and couldn't see anything. Axe at the ready Nick Gorst Web Developer BLA Pty Ltd 45 Aquarium Avenue Hemmant, Queensland 4174 Australia. Phone: (07)3890 1115 Fax: (07)3890 5388 Mob:0419 901 115 www.bla.com.au This e-mail, together with any attachments, is intended for the named recipient(s) only. If you have received this message in error, you are asked to inform the sender, mailto:[EMAIL PROTECTED] , as quickly as possible and delete this message and any copies of this message from your computer system network. Any form of disclosure, modification, distribution and/or publication of this e-mail message is prohibited. Unless otherwise stated, this e-mail represents only the views of the sender and not the views of the Bob Littler Agencies Pty Ltd --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: cffile Java.IO.FilePermision Error
As far as I'm aware, when the form is submitted the file is stored in a temp location -- it is already uploaded. When you use cffile upload you are merely moving the file from the temp location to the location you specify. Is the form enctype set enctype=multipart/form-data ? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Nick Gorst Sent: Thursday, 6 November 2003 12:09 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: cffile Java.IO.FilePermision Error Upload of a file and no the temp file does not exist. Isn't the temp file the file that is created by a CFFILE upload? I'm not sure why the system is looking for the file it mentions I certainly didn't put it in any of my code. cfif P_Vessel_Image_1 neq cffile action=upload filefield=P_Vessel_Image_1 destination=e:\inetpub\wwwroot\bla\building\images\ nameconflict=makeunique cfset ImageName = File.ServerFile /cfif Any clues? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Walker Sent: Thursday, 6 November 2003 10:01 AM To: CFAussie Mailing List Subject: [cfaussie] RE: cffile Java.IO.FilePermision Error What are you actually doing with cffile? Upload? And does that temp file exist? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Nick Gorst Sent: Thursday, 6 November 2003 11:57 a.m. To: CFAussie Mailing List Subject: [cfaussie] cffile Java.IO.FilePermision Error Hi I get the following error when trying to use CFFILE in CFMX access denied (java.io.FilePermission C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot- tmp\neotmp20763.tmp read) null brThe error occurred on line -1. I have allowed CFFILE, I have setup Sandbox security to allow writing to the directory, I have set up the directory permisions to allow web users to write to the directory. Is there something blindingly obvious missing here or do I need to start fine tuning the system with an axe :) Has anyone encountered this before? I've tried getting info from Macromedia Forums but can't find what I'm looking for (Or I'm looking for all the wrong things) I also did a search back over my cfaussie emails and couldn't see anything. Axe at the ready Nick Gorst Web Developer BLA Pty Ltd 45 Aquarium Avenue Hemmant, Queensland 4174 Australia. Phone: (07)3890 1115 Fax: (07)3890 5388 Mob:0419 901 115 www.bla.com.au This e-mail, together with any attachments, is intended for the named recipient(s) only. If you have received this message in error, you are asked to inform the sender, mailto:[EMAIL PROTECTED] , as quickly as possible and delete this message and any copies of this message from your computer system network. Any form of disclosure, modification, distribution and/or publication of this e-mail message is prohibited. Unless otherwise stated, this e-mail represents only the views of the sender and not the views of the Bob Littler Agencies Pty Ltd --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: cffile Java.IO.FilePermision Error
Here's a similar thread which doesn't seem to get far: http://houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=27669f orumid=4 -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Nick Gorst Sent: Thursday, 6 November 2003 12:20 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: cffile Java.IO.FilePermision Error Yes it is. If it isn't I get a different error. It's like the IIS server is uploading files to the wrong directory or CFMX is looking for the wrong directory. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Walker Sent: Thursday, 6 November 2003 10:14 AM To: CFAussie Mailing List Subject: [cfaussie] RE: cffile Java.IO.FilePermision Error As far as I'm aware, when the form is submitted the file is stored in a temp location -- it is already uploaded. When you use cffile upload you are merely moving the file from the temp location to the location you specify. Is the form enctype set enctype=multipart/form-data ? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Nick Gorst Sent: Thursday, 6 November 2003 12:09 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: cffile Java.IO.FilePermision Error Upload of a file and no the temp file does not exist. Isn't the temp file the file that is created by a CFFILE upload? I'm not sure why the system is looking for the file it mentions I certainly didn't put it in any of my code. cfif P_Vessel_Image_1 neq cffile action=upload filefield=P_Vessel_Image_1 destination=e:\inetpub\wwwroot\bla\building\images\ nameconflict=makeunique cfset ImageName = File.ServerFile /cfif Any clues? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Walker Sent: Thursday, 6 November 2003 10:01 AM To: CFAussie Mailing List Subject: [cfaussie] RE: cffile Java.IO.FilePermision Error What are you actually doing with cffile? Upload? And does that temp file exist? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Nick Gorst Sent: Thursday, 6 November 2003 11:57 a.m. To: CFAussie Mailing List Subject: [cfaussie] cffile Java.IO.FilePermision Error Hi I get the following error when trying to use CFFILE in CFMX access denied (java.io.FilePermission C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot- tmp\neotmp20763.tmp read) null brThe error occurred on line -1. I have allowed CFFILE, I have setup Sandbox security to allow writing to the directory, I have set up the directory permisions to allow web users to write to the directory. Is there something blindingly obvious missing here or do I need to start fine tuning the system with an axe :) Has anyone encountered this before? I've tried getting info from Macromedia Forums but can't find what I'm looking for (Or I'm looking for all the wrong things) I also did a search back over my cfaussie emails and couldn't see anything. Axe at the ready Nick Gorst Web Developer BLA Pty Ltd 45 Aquarium Avenue Hemmant, Queensland 4174 Australia. Phone: (07)3890 1115 Fax: (07)3890 5388 Mob:0419 901 115 www.bla.com.au This e-mail, together with any attachments, is intended for the named recipient(s) only. If you have received this message in error, you are asked to inform the sender, mailto:[EMAIL PROTECTED] , as quickly as possible and delete this message and any copies of this message from your computer system network. Any form of disclosure, modification, distribution and/or publication of this e-mail message is prohibited. Unless otherwise stated, this e-mail represents only the views of the sender and not the views of the Bob Littler Agencies Pty Ltd --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http
[cfaussie] RE: CFIF with () causing errors
They should function the same in MX as in previous versions. If they are causing an odd error then that's a bug, and a fairly major one I should say. We'd have noticed it by now, you'd think. You still need to use parentheses with a cfscript if() . -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Andrew Dickinson Sent: Monday, 3 November 2003 9:38 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: CFIF with () causing errors Just to clarify - () are superfluous in MX, but still necessary in previous versions, especially 4 ? Are there circumstances where () would still be necessary or, at least, not harmful (i.e. causing odd errors) ? Hi Andrew, You don't require the parenthesis in this case, and as long as the expression evaluates to a Boolean value it should work fine. eg: cfif SomeCondition = true / 1 / yes cfelse = false / 0 / no /cfif cfif not SomeCondition = false / 0 / no cfelse = true / 1 / yes /cfif cfscript if(SomeCondition) = true / 1 / yes else = false / 0 / no if(not SomeCondition) = false / 0 / no else = true / 1 / yes /cfscript If SomeCondition will not evaluate as Boolean, then you can wrap it in a function to get the result you want. eg: cfif len(SomeCondition) = true / 1 / yes /cfif cfscript if(not isNumeric(SomeCondition)) = false / 0 / no else = true / 1 / yes /cfscript Is this what you are after? Regards, Ben http://www.daemon.com.au/ -Original Message- Is the use of () in a CFIF tag problematic in MX ? CFIF (SomeCondition) --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
