XML - looking to return an XML object original parced format

2006-06-13 Thread Ian Sheridan
My subject line pretty much says it all, but let me clarify. I want to
return an XML object back to it's original format after I have used
XMLSEARCH on it. I guess it's a matter of aesthetic but I'd like to be
able to use the node name as the name of the structure I am accessing.

EX.
 root
  goodnode
   goodnode_nameDUDE/goodnode_name
  /goodnode
 /root

  parse xml 
  search xml 
  place xml in xml variable 

 cfoutput#xml.root.goodnode.goodnode_name.xmltext#!/cfoutput

  resulting in 

 DUDE!

It's a pain to do this:

 
cfoutput#xml.XmlChildren[1].XmlChildren[1].XmlChildren[1].xmltext#!/cfoutput

I figure that I am missing something and I do not want to reinvent the
wheel so to speak.


- Ian

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243326
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: XML - looking to return an XML object original parced format

2006-06-13 Thread Ian Sheridan
Well this is about returning the data structure to a state that it was
in when you first parsed the xml. Which I have figured out how to do.
Here it is:

cfset xml = xmlparse(xml) 
cfset xml = xmlsearch(xml,//root/) 
cfset xml = xml[1].tostring() 
cfset xml = xmlparse(xml) 

done... :)

- Ian

On 6/13/06, Rob Wilkerson [EMAIL PROTECTED] wrote:
 Can you use XMLSearch()?

 cfset node = XMLSearch ( parsedXML, '/root/goodnode/goodnode_name/text()' ) 
 /

 cfoutput#node[1].value#/cfoutput

 I recommend dumping the node value to ensure that the way my code
 accesses that value is correct.  It may be a little off - I'm winging
 it, here.

 On 6/13/06, Ian Sheridan [EMAIL PROTECTED] wrote:
  My subject line pretty much says it all, but let me clarify. I want to
  return an XML object back to it's original format after I have used
  XMLSEARCH on it. I guess it's a matter of aesthetic but I'd like to be
  able to use the node name as the name of the structure I am accessing.
 
  EX.
   root
goodnode
 goodnode_nameDUDE/goodnode_name
/goodnode
   /root
 
    parse xml 
    search xml 
    place xml in xml variable 
 
   cfoutput#xml.root.goodnode.goodnode_name.xmltext#!/cfoutput
 
    resulting in 
 
   DUDE!
 
  It's a pain to do this:
 
   
  cfoutput#xml.XmlChildren[1].XmlChildren[1].XmlChildren[1].xmltext#!/cfoutput
 
  I figure that I am missing something and I do not want to reinvent the
  wheel so to speak.
 
 
  - Ian
 
  --
 
  --
  Ian Sheridan
  http://www.savagevines.com
  --
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243348
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: XML - looking to return an XML object original parced format

2006-06-13 Thread Ian Sheridan
Your right I just was writing that way for brevity.

- Ian

On 6/13/06, Dawson, Michael [EMAIL PROTECTED] wrote:
 As long as you don't use the same variable xml for all of your
 function results, you won't have to re-parse the xml.  Regardless, of
 the size of the xml source, it would be a waste of processing to parse
 it twice in the same request.

 cfset xmlObj = xmlParse(xmlSource)
 cfset xmlResult = xmlSearch(xmlObj, //root/)
 cfset xmlString = xmlResult[1].toString()

 M!ke

 -Original Message-
 From: Ian Sheridan [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 13, 2006 10:24 AM
 To: CF-Talk
 Subject: Re: XML - looking to return an XML object original parced
 format

 Well this is about returning the data structure to a state that it was
 in when you first parsed the xml. Which I have figured out how to do.
 Here it is:

 cfset xml = xmlparse(xml) 
 cfset xml = xmlsearch(xml,//root/) 
 cfset xml = xml[1].tostring() 
 cfset xml = xmlparse(xml) 

 done... :)

 - Ian

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243356
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How would I send an XML file to another server/application?

2005-10-30 Thread Ian Sheridan
Wow, thank you guys so much. I was not sure about the cfhttp thing.  
Much Much appreciated!

- Ian

On 10/27/05, Anthony Prato [EMAIL PROTECTED] wrote:
 I had a client who could not figure out how to send and xml post like
 Andy's example. On my recieving page I put this code to allow them to
 post as a named form field or an xml post.

 cftry
 cfset RequestXML = FORM.xmlbody
 cfcatch
 cfset RequestXML = GetHTTPRequestData().content
 /cfcatch
 /cftry

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222650
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


How would I send an XML file to another server/application?

2005-10-27 Thread Ian Sheridan
I'm sorry that his is such a basic question but frankly I have not had
to do this outside of webservices.

I will be needing to send an xml document and will need to recieve a
responce back also an xml document. What are the mechanics of this
action? I am not really sure where to start. CFHTTP? How do I recieve
the file? CFFILE?

Hehe sorry about the noobness

- Ian

--

--
Ian Sheridan
http://www.savagevines.com
--

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222438
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Only 5 days remaining in Plum Public Beta... Be heard!

2004-12-13 Thread Ian Sheridan
Alas no one likes to support us mac users.

Ian


On Mon, 13 Dec 2004 10:45:59 -0500, Adam Churvis
[EMAIL PROTECTED] wrote:
 We want to hear your voices on what you like and don't like about the Plum
 Public Beta, and if something doesn't work for you.
 
 Remember: Plum is a *free* tool for you, and our goal is to mold it to your
 needs.
 
 We're going to release the Plum Release Candidate on Monday, December 20th,
 so we must have everyone's feedback within the next 5 days to be able to
 make changes in time.
 
 If you already have the Plum Public Beta, please send your feedback to us
 either through the Plum Discussion List at [EMAIL PROTECTED]
 or, if you're not a subscriber, to [EMAIL PROTECTED]
 
 If you don't already have the Plum Public Beta then you can download it
 from:
 http://www.productivityenhancement.com/plum/DownloadPlum.cfm
 
 Respectfully,
 
 Adam Phillip Churvis
 Member of Team Macromedia
 http://www.ProductivityEnhancement.com
 
 Download Plum and other cool development tools,
 and get advanced intensive Master-level training:
 
 * C#  ASP.NET for ColdFusion Developers
 * ColdFusion MX Master Class
 * Advanced Development with CFMX and SQL Server 2000
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187512
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Eclipse, it rocks..

2004-12-09 Thread Ian Sheridan
You guys should look at CFEclipse. When I found this I expelled a sigh
of relief at finally finding CF Studio again. and in some ways it has
surpassed some of what CF Studio did for me.

check it out at:

http://cfeclipse.tigris.org/

Ian


On Thu, 9 Dec 2004 09:53:37 -0500, Douglas Knudsen
[EMAIL PROTECTED] wrote:
 ugh, no, Aqua DataStudio, though uber kewl,  is in the flyweight
 division.  Toad does so much more.  For non devhead types , DataStudio
 is a good choice IMHO.  I really didn't feel DataStudio offered much
 more than what you get inside DWMX or HS though.
 
 D
 
 On Thu, 9 Dec 2004 20:06:27 +0800, James Holmes
 
 
 [EMAIL PROTECTED] wrote:
  Does Aqua Datastudio do everything that TOAD does? Toad is pretty
  comprehensive...
 
 
 
  -Original Message-
  From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
  Sent: Thursday, 9 December 2004 7:11
  To: CF-Talk
  Subject: Re: Eclipse, it rocks..
 
  On Thursday 09 Dec 2004 10:58 am, Dwayne Cole wrote:
   Now If can find a plugin that lets me manage the datasource including
   creating and modifying tables as well as adding, deleting, and
   updating records, I'll be as happy as a butterfly.
 
  You can use quantum inside Eclipse, but I prefer the stand alone 'Aqua
  Datastudio' - slowly converting the office work to it from Toad !
 
 
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186819
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFEXECUTE A quandary

2004-11-05 Thread Ian Sheridan
Is it possible to execute a perl script with this?


cfexecute name=perl
arguments=perl mactoipsearch -s 255.255.255.0 00-aa-22-cc-44-ee
variable=mactoip/cfexecute
cfdump var=#mactoip#


Ian

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183534
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


How to use Request scope?!

2004-11-03 Thread Ian Sheridan
can you set a request scope variable in an include?

ex.
-index.cfm
--include1.cfm -- set request.test
--include2.cfm -- read request.test

can this be done?

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183276
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to use Request scope?!

2004-11-03 Thread Ian Sheridan
well that's the thing I am setting it in include not the index.cfm file.

so I created it in the index.cfm file NOT the included file and it now works.

Ian

On Wed, 3 Nov 2004 12:41:26 -0500, Ewok [EMAIL PROTECTED] wrote:
 Sure, as long as you set it before you call it of course
 
 
 
 -Original Message-
 From: Ian Sheridan [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 03, 2004 12:38 PM
 To: CF-Talk
 Subject: How to use Request scope?!
 
 can you set a request scope variable in an include?
 
 ex.
 -index.cfm
 --include1.cfm -- set request.test
 --include2.cfm -- read request.test
 
 can this be done?
 
 --
 
 --
 Ian Sheridan
 http://www.savagevines.com
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183285
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to use Request scope?!

2004-11-03 Thread Ian Sheridan
Well let me be a little bit more descriptive. 

I have an index.cfm page that includes two files. I was then setting
the REQUEST variable *in* the first include. In the second include I
would then look for it. This did not work.

I now set the REQUEST variable in the index.cfm file first. Then set
it in the first include and read it in the second include. This works.

So I gather from this experience that request is *inherited* from the
parent document.

Application.cfm
- index.cfm
-- include.cfm

It only gets inherited. there is no creating it in a child include/file.

Ian


On Wed, 03 Nov 2004 13:05:25 -0500, Ben Doom [EMAIL PROTECTED] wrote:
 It sounds like it wasn't always being set in the first include.
 
 Regardless of what file a request variable is set in, it is available to
 all subsequent code.  I may be off a bit with regard to CFCs, but that's
 how I understand it.
 
 --Ben
 
 
 
 Ian Sheridan wrote:
  well that's the thing I am setting it in include not the index.cfm file.
 
  so I created it in the index.cfm file NOT the included file and it now works.
 
  Ian
 
 Sure, as long as you set it before you call it of course
 
 -Original Message-
 
 can you set a request scope variable in an include?
 
 ex.
 -index.cfm
 --include1.cfm -- set request.test
 --include2.cfm -- read request.test
 
 can this be done?
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183289
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to use Request scope?!

2004-11-03 Thread Ian Sheridan
Oh it is passing the right info but maybe it's because I am doing this
on a 6.0 machine

Ian

On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom [EMAIL PROTECTED] wrote:
 Except that I do exactly what you said didn't work all the time.  I
 routinely create request or variable scoped vars in one include to be
 used in another.  The includes are serial, not nested.
 
 So I don't know what your original problem was, but I'd be careful to
 check and make sure that the value being used in the second include is
 actually what's being set in the first, not in the index.
 
 --Ben
 
 
 
 Ian Sheridan wrote:
  Well let me be a little bit more descriptive.
 
  I have an index.cfm page that includes two files. I was then setting
  the REQUEST variable *in* the first include. In the second include I
  would then look for it. This did not work.
 
  I now set the REQUEST variable in the index.cfm file first. Then set
  it in the first include and read it in the second include. This works.
 
  So I gather from this experience that request is *inherited* from the
  parent document.
 
  Application.cfm
  - index.cfm
  -- include.cfm
 
  It only gets inherited. there is no creating it in a child include/file.
 
  Ian
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183294
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to use Request scope?!

2004-11-03 Thread Ian Sheridan
I was getting the actionpasser not defined in the Request scope.

This is basicly what I am doing:

!--- include1.cfm ---
cfset request.actionpasser = o.param 

!--- include2.cfm ---
cfoutput#request.actionpasser#/cfoutput

!--- index.cfm ---
cfinclude template=include1.cfm
cfinclude template=include2.cfm



On Wed, 3 Nov 2004 14:08:51 -0500, Ewok [EMAIL PROTECTED] wrote:
 Same here... I set all my request variables in one file then include it via
 Application.cfm. the request vars are available anywhere and everywhere
 throughout the entire application this way.
 
 If you have these two files...
 
 !--- Request.cfm---
 cfset request.testvar = request variable
 
 !--- index.cfm ---
 cfinclude template=request.cfm
 cfoutput#request.testvar#/cfoutput
 
 Index.cfm should just display request variable
 
 This SHOULD definitely work. If it's not, then there is something wrong
 somewhere else. Were you getting test not defined in request scope errors?
 Or any kind of error for that matter...
 
 
 
 -Original Message-
 From: Ben Doom [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 03, 2004 1:26 PM
 To: CF-Talk
 Subject: Re: How to use Request scope?!
 
 Except that I do exactly what you said didn't work all the time.  I
 routinely create request or variable scoped vars in one include to be
 used in another.  The includes are serial, not nested.
 
 So I don't know what your original problem was, but I'd be careful to
 check and make sure that the value being used in the second include is
 actually what's being set in the first, not in the index.
 
 --Ben
 
 Ian Sheridan wrote:
  Well let me be a little bit more descriptive.
 
  I have an index.cfm page that includes two files. I was then setting
  the REQUEST variable *in* the first include. In the second include I
  would then look for it. This did not work.
 
  I now set the REQUEST variable in the index.cfm file first. Then set
  it in the first include and read it in the second include. This works.
 
  So I gather from this experience that request is *inherited* from the
  parent document.
 
  Application.cfm
  - index.cfm
  -- include.cfm
 
  It only gets inherited. there is no creating it in a child include/file.
 
  Ian
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183306
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to use Request scope?!

2004-11-03 Thread Ian Sheridan
oh yeah it works I am getting the expected value in o.param.


On Wed, 3 Nov 2004 15:15:46 -0800, Sean Corfield [EMAIL PROTECTED] wrote:
 Have you checked that o.param contains a valid value?
 
 
 
 On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan [EMAIL PROTECTED] wrote:
  I was getting the actionpasser not defined in the Request scope.
 
  This is basicly what I am doing:
 
  !--- include1.cfm ---
  cfset request.actionpasser = o.param 
 
  !--- include2.cfm ---
  cfoutput#request.actionpasser#/cfoutput
 
  !--- index.cfm ---
  cfinclude template=include1.cfm
  cfinclude template=include2.cfm

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183318
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to use Request scope?!

2004-11-03 Thread Ian Sheridan
o.param is a string that I get out of a CFPROCEDURE it's there and
avaiable. I have focused it down to the setting the request variable.

when I dump and abort the o.param it's there.

Ian


On Wed, 3 Nov 2004 17:02:11 -0800, Sean Corfield [EMAIL PROTECTED] wrote:
 On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan [EMAIL PROTECTED] wrote:
  oh yeah it works I am getting the expected value in o.param.
 
 Where is o.param set? You didn't show that in your cut-down code...
 
!--- include1.cfm ---
cfset request.actionpasser = o.param 
   
!--- include2.cfm ---
cfoutput#request.actionpasser#/cfoutput
   
!--- index.cfm ---
cfinclude template=include1.cfm
cfinclude template=include2.cfm
 -- 
 Sean A Corfield -- http://www.corfield.org/
 Team Fusebox -- http://www.fusebox.org/
 Got Gmail? -- I have 1 invite
 
 If you're not annoying somebody, you're not really alive.
 -- Margaret Atwood
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183327
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Getting 4 results where there should be only 2

2004-10-25 Thread Ian Sheridan
You need to join the data:

select *
from table1, table2
where table1.id = table2.FKid

table2 should hold the ID of the record it belongs to in table1.

or vice versa


Ian

On Mon, 25 Oct 2004 14:51:58 -0400, Ewok [EMAIL PROTECTED] wrote:
 You could try grouping by something distinct or selecting distinct
 
 -Original Message-
 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 Sent: Monday, October 25, 2004 2:45 PM
 To: CF-Talk
 Subject: Getting 4 results where there should be only 2
 
 When I do something like this...
 
 cfquery datasource=#mydbname# name=getinfo
 SELECT *
 FROM Table1,Table2
 /cfquery
 
 and there are only 2 records to show, the output shows those 2 records
 twice. I'm assuming that its becuase there are 2 tables so it shows it
 twice. How do I get around this? This page is independant and has no
 variables passed to it from urls or forms.
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182530
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Field Naming

2004-10-19 Thread Ian Sheridan
Andrew,

I usually go with this method:

Name of application == My Sample Application == msa_

Table for users == msa_usr_users

User table fields ==

 usr_id
 usr_firstname
 usr_lastname

And a Foreign Key would be like so ==

 usr_uro_id (this would be a foreign key to the userroles table)

This way when I do joins i do not have any confusion what table a
column is from. Also I always use plurals in the table name because I
do not have a tables that has only *one* item in it.

Ian

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181830
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Field Naming

2004-10-19 Thread Ian Sheridan
Jochem,

Your right, but when you have multiple apps using the same DB or when
the user account does not have permissions to do CREATE SCHEMA, this
comes in handy for me. Also, I do the 'My Sample Application' ==
msa_ thing anyway in my file naming so this helps in keeping things
straight in my head.

The more important part of my naming convention is the table name
after the app abbr. This way I know what column goes to what table
without any guesswork (helps with knowledge transfer too). Also the
app abbr comes in handy when I have multiple user tables (or other
similar tables).

Ian


On Tue, 19 Oct 2004 16:06:59 +0200, Jochem van Dieten
[EMAIL PROTECTED] wrote:
 Ian Sheridan wrote:
 
  Name of application == My Sample Application == msa_
 
  Table for users == msa_usr_users
 
 Application prefix? Isn't that what schema's are for?
 CREATE SCHEMA msa ...
 CREATE TABLE msa.users ...
 
 Jochem


-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181857
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: WWOT: OS X for Intel?

2004-09-20 Thread Ian Sheridan
Mike,

I disagree with you. Just because we have learned how to deal with the
way that Windows GUI functions does not mean that that is the best way
that it should of been done. If fact I would say that most of the time
they do it wrong but they are consistently wrong. So, I guess, in a
warped way it works.

Lets take iTunes. The users that you where demonstrating the
application to were so used to hunting through the menus they did not
figure out the very evident burn button. My question is this: How is
hunting through the menus better then a simple button in the upper
right hand corner of the main window better? How long did the user
take to figure out it's use and once that was learned I would say they
had an easier time from then on.

Ok, lets take your comment [other operating systems] maintain a
visual standard of always having certain menus. I beg to differ. I
have always found the File menu item, the Edit menu item in many
menu on a variety of different OSs. Yet other then those two items the
menus have been different for almost every single application that i
have used (yes on Mac, Linux and Windows).

Your focus on a single OS I think is incomplete in it's scope. I would
go down the road of getting, us the programers, to design a better UI
that would function well across all OSs. There are failing in all OSs,
but with that said I prefer Mac over all the others.

Ian
-- 

--
Ian Sheridan
http://www.savagevines.com
--

- Original Message -
From: Mike Kelp [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 10:45:37 -0500
Subject: Re: WWOT: OS X for Intel?
To: CF-Talk [EMAIL PROTECTED]

I think a lot of people go too far in giving Apple's UI such high
 scores. Personally, I think that no OS deserves a near perfect score
 for it. A UI is far more than pretty buttons and smooth gradients that
 look cool. Apple has a huge problem with UI in the sense that when
 installing varying applications from apple or other vendors on the
 macintosh platform there is absolutely no visual standard for creating
 the GUI.

 For whatever reason, (not to say that this is on purpose) apps written
 for Windows and even many linux applications seem to maintain a visual
 standard of always having certain menus that users can reference when
 searching for functions and they give the user a order of operations
 for finding a feature or at least finding help. While I'm sure
 Microsoft will find a way to mess up one good thing about the UI for
 PC software, this is a good example of a place where I think Apple
 fails miserably. This is particularly true for iTunes as many users
 that I have shown iTunes to both on mac and PC have a lot of trouble
 finding out that the radioactive-like symbol is a button for burn cd
 and objects that look like status information in the current track
 display are also buttons.

 On the other hand, apple does offer a more inviting look in their UI
 and encourages users to become more interested than in Windows. I
 think there are a lot of valuable points for Apple there. I would
 basically reverse the tables on this topic.

 Point being, I think we often forget what we are talking about when we
 say UI in place of cool look. As developers, being able to
 consider a user's ability to find things and use them efficiently is
 just as valuable or more than getting them to say it looks neat and
 we should never forget that important goal of our jobs.

 Sorry for the long post and thanks to anybody willing to read the
 whole thing hehe.

 -- 
 Mike Kelp

 --Education's purpose is to replace an empty mind with an open one.
 ~Malcolm S. Forbes
 --If knowledge is power, know this is tyranny.
 ~Thrice
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CSS Editor (Good CSS Developer)

2004-09-18 Thread Ian Sheridan
Valid CSS isn't exactly cross browser.

- Original Message -
From: Jim Davis [EMAIL PROTECTED]
Date: Fri, 17 Sep 2004 12:41:53 -0400
Subject: RE: CSS Editor (Good CSS Developer)
To: CF-Talk [EMAIL PROTECTED]

Better yet you could hire me and I'll use the W3C CSS Validation service.
 ;^)

 Jim Davis

 
_

 From: Rebecca Wells [mailto:[EMAIL PROTECTED] 
 Sent: Friday, September 17, 2004 12:21 PM
 To: CF-Talk
 Subject: Re: CSS Editor (Good CSS Developer)

You could use the W3C CSS Validation Service:
 http://jigsaw.w3.org/css-validator/

  Dwayne Cole [EMAIL PROTECTED] 9/17/2004 06:36:05 AM 
 TopStyle seems to perform better than StyleMaster but Stylemaster seems
 to provide better window into the HTML impact of your CSS.

 I'm looking for a company that can take my style sheets and either 

 1). Make sure that they are cross-browser compatible or
 2). Generate a version of the style sheet for IE on Mac and PC,
 Monzilla, etc.

 If you know of anyone please let me know.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: XML parsing in ColdFusion

2004-09-02 Thread Ian Sheridan
I suggest that create a new XML doc and place all the information form
bothe xml docs in the new one.

here is a sample bit of code that I use to create a xml object.

xmloutput = xmlnew();
xmloutput.XmlRoot = XmlElemNew(t.xmloutput,entries);
xmloutput.entries.XmlChildren[1] = xmlelemnew(xmloutput,entry);
xmloutput.entries.XmlChildren[1].xmltext = xmlformat(dude an entry);

As you can see you can treat the XmlChildren node as an array. loop
over the output from the two old XML files.

Hope it helps

Ian

- Original Message -
From: Ian Skinner [EMAIL PROTECTED]
Date: Thu, 2 Sep 2004 12:04:07 -0700
Subject: RE: XML parsing in ColdFusion
To: CF-Talk [EMAIL PROTECTED]

I'm still not getting this to work.I tried using what you provided,
but I'm only getting errors like the following.

 WRONG_DOCUMENT_ERR: That node doesn't belong in this document.

 Error casting an object of type to an incompatible type. This
usually indicates a programming error in Java, although it could also
mean you have tried to use a foreign object in a different way than it
was designed.

 My test code:

 cfxml variable=doc1
 root
 member id=10
 nameIan/name
 sexmale/sex
 /member
 /root
 /cfxml

 cfxml variable=doc2
 root
 member id=1
 nameJoe/name
 sexmale/sex
 /member
 member id=2
 nameJohn/name
 sexmale/sex
 /member
 member id=3
 nameSue/name
 sexfemale/sex
 /member
 /root
 /cfxml

 !--- Three versions of this line I tried ---
 cfset doc2.root.xmlChildren[4] = xmlElemNew(doc1, member)!---
Alternate 1 ---
 cfset doc2.root.xmlChildren[4] = xmlElemNew(doc1.root,
member)!--- Alternate 2 ---
 cfset doc2.root.xmlChildren[4] = xmlElemNew(doc1.root.member,
member)!--- Alternate 3 ---

 !--- If I code the line this way, I don't get an error, I do get a
new member, but it is not populated.If I could copy the member node
from doc 1 to this doc, then all would be well. But I can't seem to do
that.---
 cfset doc2.root.xmlChildren[4] = xmlElemNew(doc2, member)

 cfdump var=#doc2 # label=Doc Two

 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org

Sacramento, CA

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Postgres, ColdFusion and Transactions

2004-09-01 Thread Ian Sheridan
Sounds like the query is cached. Set the chachedwithin to 0. That should help.

Ian

- Original Message -
From: Hansjoerg Posch [EMAIL PROTECTED]
Date: Wed, 01 Sep 2004 07:50:07 +0200
Subject: Postgres, ColdFusion and Transactions
To: CF-Talk [EMAIL PROTECTED]

Hello!

 I've got the following problem: Commits seem to be executed in a deferred mode.

 An example:

 1) DELETE some rows ... commit the transaction

 2) SELECT rows ... the rows deleted in 1) are still displayed

 3) After a reload of the page the rows of 1) have dissapeared

 I've already tried to add a cftransaction statement with 
 isolation=read_uncommitted to the SELECT statement but it does not help.

 Software: ColdFusion MX, Postgres 7.3 (debian stable release), JDBC driver for 
 7.3

 Is this a known problem?

 Peter
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: FTP client that works like Dreamweaver's site manager?

2004-09-01 Thread Ian Sheridan
you can write upload scripts in eclipse? can you direct me to any
documentation about this?

- Original Message -
From: Mark Drew [EMAIL PROTECTED]
Date: Wed, 1 Sep 2004 15:53:53 +0200
Subject: Re: FTP client that works like Dreamweaver's site manager?
To: CF-Talk [EMAIL PROTECTED]

Something like that would rule

 I use ant integrated into cfeclipse to write upload scriptsbut that
 is another story

 MD

On Wed, 1 Sep 2004 09:49:29 -0400, Damien McKenna
 [EMAIL PROTECTED] wrote:
  I'm looking for an FTP client that works like Dreamweaver's site
  manager.The idea is that I would simply have a list of my local
  files, be able to click Upload and have it uploaded to the correct
  directory on the site, rather than having to search through the
  directory structure on the server the way that most clients work.Any
  suggestions?I've got a license for WS_FTP 8 but want to verify my
  options before installing it, or something else.Thanks.
  --
  Damien McKenna - Web Developer - [EMAIL PROTECTED]
  The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
  Nothing endures but change. - Heraclitus
  
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: galleon

2004-08-30 Thread Ian Sheridan
I have everything else (in MS Office) except for access. Shrug what
can ya do. I certainly have no control over M$ greed. So I do without
and usually what I substitute with is usually better. So I can't say
that I am worse off.

Ian

- Original Message -
From: dave [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 16:02:45 -0400
Subject: Re: galleon
To: CF-Talk [EMAIL PROTECTED]

doesnt help when your platform wont support m$ products

-- Original Message --
 From: Qasim Rasheed [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date:Mon, 30 Aug 2004 15:35:54 -0400

 Have you thought about using SQL server Express instead of Access?
 
 Qasim
 
 
 - Original Message -
 From: Ian Sheridan [EMAIL PROTECTED]
 Date: Mon, 30 Aug 2004 15:26:41 -0400
 Subject: Re: galleon
 To: CF-Talk [EMAIL PROTECTED]
 
 I would defiantly advocate for support of MySQL. Why? I develop on a
 MAC and I have MySQL installed. and I stage on Solaris so I really do
 not have access to MS Access. There are a bunch of other pluses to
 having MySQL but I'm sure you know the list.
 
 Ian
 
 
 
 On Mon, 30 Aug 2004 10:30:46 -0500, Raymond Camden [EMAIL PROTECTED] wrote:
  There will be an official mysql release. Do people think mysql support
 is more important than ms access?
  
  
 
 On Mon, 30 Aug 2004 02:40:10 -0400, dave [EMAIL PROTECTED] wrote:
  has anyone converted this too mysql yet?
  (from raymond on devnet 8)
  
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: galleon

2004-08-30 Thread Ian Sheridan
I agree with Qasim.

The argument of most people have access to [MS] Access is
irrelevant. We are Developers we have access to MySQL (if you don't
have it, it would be worth your while to install it and try it out).
We are not the normal users who does not even know if they have MS
Access on their machines in the first place. So I do not see this
argument lending credence to choosing MS Access.

While yes I can take the MS Access DB file and use it on a *NIX
machine but having no direct access to the DB to affect any change to
it is a big minus in my book. While MySQL can be on Win, Mac or *NIX
machine is big a plus. Not to mention all the other benefits that come
with using MySQL. A forum can be a very highly trafficked area of your
site and MySQL can hold up under that type of use much better. I can
name a few more things but it's nearing end of work the day, brain
starting to fiz and pop.

Ian

- Original Message -
From: Qasim Rasheed [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 16:29:36 -0400
Subject: Re: galleon
To: CF-Talk [EMAIL PROTECTED]

Well its an ongoing argument whether to use MS product or not. I just
 recommended since its a better db than access and free.

 Qasim

- Original Message -
 From: dave [EMAIL PROTECTED]
 Date: Mon, 30 Aug 2004 16:02:45 -0400
 Subject: Re: galleon
 To: CF-Talk [EMAIL PROTECTED]

 doesnt help when your platform wont support m$ products

 -- Original Message --
 From: Qasim Rasheed [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date:Mon, 30 Aug 2004 15:35:54 -0400

 Have you thought about using SQL server Express instead of Access?
 
 Qasim
 
 
 - Original Message -
 From: Ian Sheridan [EMAIL PROTECTED]
 Date: Mon, 30 Aug 2004 15:26:41 -0400
 Subject: Re: galleon
 To: CF-Talk [EMAIL PROTECTED]
 
 I would defiantly advocate for support of MySQL. Why? I develop on a
 MAC and I have MySQL installed. and I stage on Solaris so I really do
 not have access to MS Access. There are a bunch of other pluses to
 having MySQL but I'm sure you know the list.
 
 Ian
 
 
 
 On Mon, 30 Aug 2004 10:30:46 -0500, Raymond Camden [EMAIL PROTECTED] wrote:
  There will be an official mysql release. Do people think mysql support
 is more important than ms access?
  
  
 
 On Mon, 30 Aug 2004 02:40:10 -0400, dave [EMAIL PROTECTED] wrote:
  has anyone converted this too mysql yet?
  (from raymond on devnet 8)
  
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CFEclipse question

2004-08-30 Thread Ian Sheridan
Use \) \( the back slash is used for this.

Ian

- Original Message -
From: Peter Nyberg [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 16:42:00 -0500
Subject: CFEclipse question
To: CF-Talk [EMAIL PROTECTED]

I just started using Eclipse + CFEclipse and absolutely love it (OSX, 
 used BBEdit before trying this). However, one thing I wonder is if 
 anyone knows if there's a way to find matching parenthesis, brackets 
 and tags? That's about the only major complaint I have.

 Peter Nyberg
 Northwestern University, Chicago, IL USA
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: regexp help

2004-08-30 Thread Ian Sheridan
Why don;t you just go through the text as a list with CR as the
delimiter? This way you can have much more focused regular
expressions.

Just a thought,

Ian

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 16:49:48 -0400
Subject: RE: regexp help
To: CF-Talk [EMAIL PROTECTED]

Really fast (Using the multi-line move of CFMX)

^([^#chr(13)#]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]{2
 }/[0-9]{2}/[0-9]{4})[[:space:]]+(USD)?[[:space:]]*([0-9.]+)$

 
_

 From: chris porter [mailto:[EMAIL PROTECTED] 
 Sent: Monday, August 30, 2004 4:41 PM
 To: CF-Talk
 Subject: Re: regexp help

and one last time

 DATA:

 Product Name
 Product NumberQtyEst. Ship DateYour Ext.
 Price
 [dashed go here all the way across PITA email parser]

 description of some item1
 0344437103/12/2004USD
 335.75

 another description of some item1
 0344734103/12/2004USD
 335.75

 and one last description of some item
 0433447103/12/2004USD
 335.75

 part i need parsed by a regex

 description of some item1
 0344437103/12/2004USD
 335.75

 current REGEX:
 ([0-9]+)[ ]+([0-9]+)[ ]+([^ ]+)[ ]+([A-Z]{3})[ ]+([0-9.]+)

 that regex matches everything on the 2nd line correctly, but nothing i add
 to the beginning will match the first line. any thoughts?

 Thanks!
 -Chris 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CFEclipse question

2004-08-30 Thread Ian Sheridan
oops well I shot that off fast. but I still use BBEdit myself.

I see what you mean, this is a question best answered by the CFEclipse
developers. It's a functionality that is not there they might be able
to place it in there but I am not sure.

why don;t you join the mailing list for CFEclipse

http://cfeclipse.tigris.org/servlets/ProjectMailingListList

Ian

- Original Message -
From: Peter Nyberg [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 18:33:54 -0400
Subject: Re: CFEclipse question
To: CF-Talk [EMAIL PROTECTED]

Ok, I realize I wasn't very clear, although I think you got the point
below. Just like you can jump to the end tag (thanks for the tip!), I
wonder if there's a way in a cfscript section to either jump to the
corresponding } or for the editor to highlight the whole code block in
between the { and }. This is something I think is fairly common in
other editors (for example bbedit and emacs).

 Thanks!

 Hi Peter,
 
 I'm not 100% sure what it is you mean by the comment below.
 
 Any chance you could expand on it?
 
 FWIW you can right-click on an opening tag and jump to the end tag, but I'm
 not sure that's what you're after.
 
 Spike
 
 
 Stephen Milligan
 Code poet for hire
 http://www.spike.org.uk
 
 Do you cfeclipse? http://cfeclipse.tigris.org 
 
 
  
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: regexp help

2004-08-30 Thread Ian Sheridan
I understand that, what I meant was, wouldn't it be easier to parse
each line separately? This way you do not need to have such a highly
complicated RegEx. You can make it much more simple and a little bit
more flexible. Not to mention easier to maintain. (i.e. two separate
regular expressions or more)

cfscript
email = emailFromServer; // focused down to the body content only
n = listlen(email,chr(13)  chr(32));
output = arraynew(1);
output[1] = structnew();
a = arraynew(2);
a[1][1] = RegEx;
a[1][2] = description;
a[2][1] = RegEx;
a[2][2] = productnumber;
nn = arraylen(a); // regex count
nnn = 1; // record count
c = 0; // field count
for (i=1:i LTE n;i=i+1) {
currentitem = listgetat(email,i,chr(13)  chr(32));
for (ii=1;ii LTE nn;ii=ii+1) {
if (refind(a[i][1],currentitem)) {
output[nnn]['#a[i][2]#'] = trim(currentitem);
if (c GT 5) {
c = 0;
nnn = nnn + 1;
output[nnn] = structnew();
} else {
c = c +1;
}
}
}
}
/cfscript

heh I went a little crazy here but I pretty sure this would work. Any
future changes on what each feild would hold would be easy to change.
(beware I did not test it)

Ian

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 18:23:04 -0400
Subject: RE: regexp help
To: CF-Talk [EMAIL PROTECTED]

You can get the first and second lines based on a new line delimited list
 and you can get the items in the second line using a space delimited list. I
 just like to be specific when parsing data from a source like email. My
 preference is to pop 2 messages, save the first in a DB (raw) and use the
 second as a flag to rerun the page. Once all the mail is down and stored in
 the DB (one at a time, there's a reason), I have a second process parse each
 message in the tightest way possible. I'm paranoid (as all programmers
 should be) about data from outside sources and I want to be 100% sure of
 what I'm getting and how. If there's a problem, then I want to know exactly
 what's up. 

 
_

Why don;t you just go through the text as a list with CR as the
 delimiter? This way you can have much more focused regular
 expressions.

 Just a thought,

 Ian

 - Original Message -
 From: Michael Dinowitz [EMAIL PROTECTED]
 Date: Mon, 30 Aug 2004 16:49:48 -0400
 Subject: RE: regexp help
 To: CF-Talk [EMAIL PROTECTED]

 Really fast (Using the multi-line move of CFMX)

 ^([^#chr(13)#]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]{2
 }/[0-9]{2}/[0-9]{4})[[:space:]]+(USD)?[[:space:]]*([0-9.]+)$

 
 _

 From: chris porter [mailto:[EMAIL PROTECTED] 
 Sent: Monday, August 30, 2004 4:41 PM
 To: CF-Talk
 Subject: Re: regexp help

 and one last time

 DATA:

 Product Name
 Product NumberQtyEst. Ship DateYour Ext.
 Price
 [dashed go here all the way across PITA email parser]

 description of some item1
 0344437103/12/2004USD
 335.75

 another description of some item1
 0344734103/12/2004USD
 335.75

 and one last description of some item
 0433447103/12/2004USD
 335.75

 part i need parsed by a regex

 description of some item1
 0344437103/12/2004USD
 335.75

 current REGEX:
 ([0-9]+)[ ]+([0-9]+)[ ]+([^ ]+)[ ]+([A-Z]{3})[ ]+([0-9.]+)

 that regex matches everything on the 2nd line correctly, but nothing i add
 to the beginning will match the first line. any thoughts?

 Thanks!
 -Chris
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: regexp help

2004-08-30 Thread Ian Sheridan
heh after talk'n out of my but this should work for you

([[:alnum:] ]+)\r\s*([0-9]{7})\s*([0-9]+)\s*([0-3][0-9]/[0-1][0-9]/[0-9]{4})\s*([A-Z]{2,3})\s*([0-9]+\.[0-9]{2})

You have to add some of your own business logic to not parse the this
is just a confirmation email emails. I do not know all the codes that
you are using with the USD codes so I left it like this: [A-Z]{2,3}

I just hope that I have helped somewhere.

Ian

- Original Message -
From: chris porter [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 21:40:53 -0400
Subject: Re: regexp help
To: CF-Talk [EMAIL PROTECTED]

that was an option i explored, however these emails arent coming from
just one source, in fact there are hundreds of different company
emails coming in, so my options were, either 1) define the data i
need, and specify a regex to grab it, then database the expressions,
or 2) write a custom script in code that can identify each one of
those possibly by regex. personally i opted for option a cause i can
always fine tune an _expression_, but changing code gets tedious.

 on another note, what distinguishes the item description line during
a line by line scan from something like

 this is just a confirmation email.

 get my drift?
 -chris

I understand that, what I meant was, wouldn't it be easier to parse
 each line separately? This way you do not need to have such a highly
 complicated RegEx. You can make it much more simple and a little bit
 more flexible. Not to mention easier to maintain. (i.e. two separate
 regular expressions or more)
 
 cfscript
 email = emailFromServer; // focused down to the body content only
 n = listlen(email,chr(13)  chr(32));
 output = arraynew(1);
 output[1] = structnew();
 a = arraynew(2);
 a[1][1] = RegEx;
 a[1][2] = description;
 a[2][1] = RegEx;
 a[2][2] = productnumber;
 nn = arraylen(a); // regex count
 nnn = 1; // record count
 c = 0; // field count
 for (i=1:i LTE n;i=i+1) {
 currentitem = listgetat(email,i,chr(13)  chr(32));
 for (ii=1;ii LTE nn;ii=ii+1) {
 if (refind(a[i][1],currentitem)) {
 output[nnn]['#a[i][2]#'] = trim(currentitem);
 if (c GT 5) {
 c = 0;
 nnn = nnn + 1;
 output[nnn] = structnew();
 } else {
 c = c +1;
 }
 }
 }
 }
 /cfscript
 
 heh I went a little crazy here but I pretty sure this would work. Any
 future changes on what each feild would hold would be easy to change.
 (beware I did not test it)
 
 Ian
 
 
 - Original Message -
 From: Michael Dinowitz [EMAIL PROTECTED]
 Date: Mon, 30 Aug 2004 18:23:04 -0400
 Subject: RE: regexp help
 To: CF-Talk [EMAIL PROTECTED]
 
 You can get the first and second lines based on a new line delimited list
  and you can get the items in the second line using a space delimited list. I
  just like to be specific when parsing data from a source like email. My
  preference is to pop 2 messages, save the first in a DB (raw) and use the
  second as a flag to rerun the page. Once all the mail is down and stored in
  the DB (one at a time, there's a reason), I have a second process parse each
  message in the tightest way possible. I'm paranoid (as all programmers
  should be) about data from outside sources and I want to be 100% sure of
  what I'm getting and how. If there's a problem, then I want to know exactly
  what's up. 
  
 _
 
 
  
  Why don;t you just go through the text as a list with CR as the
  delimiter? This way you can have much more focused regular
  expressions.
  
  Just a thought,
  
  Ian
  
  - Original Message -
  From: Michael Dinowitz [EMAIL PROTECTED]
  Date: Mon, 30 Aug 2004 16:49:48 -0400
  Subject: RE: regexp help
  To: CF-Talk [EMAIL PROTECTED]
  
  Really fast (Using the multi-line move of CFMX)
  
  ^([^#chr(13)#]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]{2
  }/[0-9]{2}/[0-9]{4})[[:space:]]+(USD)?[[:space:]]*([0-9.]+)$
  
  _
  
  From: chris porter [mailto:[EMAIL PROTECTED] 
  Sent: Monday, August 30, 2004 4:41 PM
  To: CF-Talk
  Subject: Re: regexp help
  
  and one last time
  
  DATA:
  
  Product Name
  Product NumberQtyEst. Ship DateYour Ext.
  Price
  [dashed go here all the way across PITA email parser]
  
  description of some item1
  0344437103/12/2004USD
  335.75
  
  another description of some item1
  0344734103/12/2004USD
  335.75
  
  and one last description of some item
  0433447103/12/2004USD
  335.75
  
  part i need parsed by a regex
  
  description of some item1
  0344437103/12/2004USD
  335.75
  
  current REGEX:
  ([0-9]+)[ ]+([0-9]+)[ ]+([^ ]+)[ ]+([A-Z]{3})[ ]+([0-9.]+)
  
  that regex matches everything on the 2nd line correctly, but nothing i add
  to the beginning will match the first line. any thoughts?
  
  Thanks!
  -Chris
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Document Management System

2004-08-29 Thread Ian Sheridan
The thing about what you asked for it is most likely already made. I
know at my company we have one (I did not participate in it creation),
but I can't go placing the code and DB schema out here for you.

I suggest that you start an Open Source project. I have been seeing
the OpenXCF a bunch lately. Check it out. it's only just started but
something like this would be of great value to the CF community. I'm
sure a few of us would like to contribute.

http://openxcf.sourceforge.net/

Ian

- Original Message -
From: Ciliotta, Mario [EMAIL PROTECTED]
Date: Fri, 27 Aug 2004 19:00:00 +0100
Subject: Document Management System
To: CF-Talk [EMAIL PROTECTED]

Hi,

I was wondering if anyone knows of a good document management system,
 hopefully written in CF.I am looking for something where my users can upload
 files and then the files and/or files can have permissions set on them so that
 only certain people can view the files.It will be mainly for storing
 spreadsheets and word doc in.

I am sure that someone has developed this already so I why re-invent the
 wheel.

Thanks
 Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Download file

2004-08-28 Thread Ian Sheridan
heh Oh ok cool glad to help didn't think that I was being that helpful
but you never know. It's always the little things that get you.

- Original Message -
From: Andy Ousterhout [EMAIL PROTECTED]
Date: Sat, 28 Aug 2004 08:24:21 -0500
Subject: RE: Download file
To: CF-Talk [EMAIL PROTECTED]

Thanks.I was using file path (D:\etc) like I used to create the file and
 forgot to change to http://.

 Thanks for helping me with my brain cramp.

 Andy

-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED]
Sent: Friday, August 27, 2004 10:48 AM
To: CF-Talk
Subject: Re: Download file

 
heh, man ok place this in your HTML doc:

 
a href="">
this file/a

 
Ian

 
- Original Message -
From: Andy Ousterhout [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 21:37:03 -0500
Subject: RE: Download file
To: CF-Talk [EMAIL PROTECTED]

 
Actually, you are right on that this is probably so easy that you don't
understand why I am asking.I just don't know how to put the direct link
 in.

 
-Original Message-
From: Chris Johnston [mailto:[EMAIL PROTECTED]

 
 I am still a little unclear as to what exactly you are trying to
accomplish here. You create a csv file on the server that you would
like your users to be able to download. So why not just put a direct
link to the file in a webpage. The user then has the ability to do
whatever they like with the
file.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: UML Modeling

2004-08-27 Thread Ian Sheridan
wow thanks for pointing out ArgoUML. works great. Now somebody has to
create the XMI translation CFCs. I would try but I just don't have the
time at the moment.

Ian

- Original Message -
From: Rob [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 11:44:20 -0700
Subject: Re: UML Modeling
To: CF-Talk [EMAIL PROTECTED]

I like ArgoUML - it has the ability to export to the XMI standard
 (which is xml).
 From there you can XSLT your way to CFCs. It also keeps you from being
 tied to just the one product.

 (As an aside, I am, amongst other things, working on a xslt to
 translate an XMI to CFCs.)

 If you want flexabilty with your modeling I would recommend you pick
 one that does support exporting to XMI.

 Argo is cool - its a bit slow and a bit non-intuitive but the best
 open source one I have found (aside from Dia (linux) and the one that
 comes free on Mac - which doesn't export to XMI)

On Thu, 26 Aug 2004 14:07:33 -0400, Dan O'Keefe [EMAIL PROTECTED] wrote:
  Any tool recomendations for modeling a MX app's CFC's? Not the
  Rational Rose level, something within reach. I see Tigris has ArgoUML
  
  Dan
  
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Download file

2004-08-27 Thread Ian Sheridan
heh, man ok place this in your HTML doc:

a href="">
this file/a

Ian

- Original Message -
From: Andy Ousterhout [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 21:37:03 -0500
Subject: RE: Download file
To: CF-Talk [EMAIL PROTECTED]

Actually, you are right on that this is probably so easy that you don't
 understand why I am asking.I just don't know how to put the direct link in.

-Original Message-
From: Chris Johnston [mailto:[EMAIL PROTECTED]

 
 I am still a little unclear as to what exactly you are trying to
accomplish here. You create a csv file on the server that you would
like your users to be able to download. So why not just put a direct
link to the file in a webpage. The user then has the ability to do
whatever they like with the file.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: stored procedures

2004-08-26 Thread Ian Sheridan
Can you really say that for Oracle? Point out any material on the net
that talks about it?

I'm actually curious about this. So if you have any links that talk
further about this that would be great.

Ian

--
Ian Sheridan
http://www.savagevines.com
--

- Original Message -
From: Micha Schopman [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 12:53:28 +0200
Subject: RE: stored procedures
To: CF-Talk [EMAIL PROTECTED]

Stored procedures are NOT pre-compiled. This is a common made mistake.
 Only the execution plan gets cached, but the stored procedure is
 compiled upon execution.

Micha Schopman 
 Software Engineer 
 Modern Media, Databankweg 12 M, 3821 ALAmersfoort 
 Tel 033-4535377, Fax 033-4535388 
 KvK Amersfoort 39081679, Rabo 39.48.05.380
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: querying an array?

2004-08-26 Thread Ian Sheridan
why don't you just place the array in a query and query that query?
(might be overkill though)

or loop through the array and output only the rows that don't have
Green in row[n][3]

Ian

--
Ian Sheridan
http://www.savagevines.com
--

- Original Message -
From: mc [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 11:33:51 +0200
Subject: querying an array?
To: CF-Talk [EMAIL PROTECTED]

I've got a shopping cart that is in an array (stored in a session). It looks
 like this:

 ItemQuantityType
 -
 pepper2green
 avocado 1green
 carrot3not green
 eggplant1not green
 celery5green

 What I need to do is figure out the total quantity of not green items and
 green items (in this case, 8 green items; 4 not green items).

 I'm not at all sure how to go about this, as I've always used databases and
 queries to do this sort of thing. Am I out of luck or is there some way to
 query the data in an array that isn't too horribly complicated?

 P.S. Please forgive me if this issue has already been dealt with here. I
 just took a two year break from CF and my brain is a bit out of shape...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Web Services

2004-08-25 Thread Ian Sheridan
I am having trouble with sending an xml doc to the user of my web
service. That user being me I am getting this error message:

Could not perform web service invocation getUsers because 
java.lang.ClassCastException: java.lang.String

I transform a query to xml and the xml to a string. I have done this
before with success but am now having trouble. The code below is the
function in the CFC. As you can see I am making this a facade to my
other CFCs. I am pretty sure that this should work but it isn't.

t.output.result = query, queryToXML outputs a valid xml object

- - - - - START CODE - - - - - -

	cffunction name=getUsers access=remote output=false returntype=string
		hint=This Function outputs a structure of thee variables; result
(the resulting query), pass (boolean value telling you if the query
was succesfully run), message (the error message from the server if
query failed.)
		cfargument name=showinactive type=boolean required=false
default=false
			hint=show the inactive accounts?
		cfset var t = structnew()!--- temporary variables ---
		cfset var o = structnew()!--- output variables ---
		cfscript
			// get results
			t.output = createobject(component,uau.com.users).getUsers(arguments.showinactive);
			o.result = createobject(component,uau.com.utility).queryToXML(t.output.result,users,user);
			o.final = tostring(o.result);
		/cfscript
		cfreturn o.final
	/cffunction

- - - - - END CODE - - - - - -

-- 

--
Ian Sheridan
http://www.savagevines.com
--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Web Services

2004-08-25 Thread Ian Sheridan
I am having trouble with sending an xml doc to the user of my web
service. That user being me I am getting this error message:

Could not perform web service invocation getUsers because
java.lang.ClassCastException: java.lang.String

I transform a query to xml and the xml to a string. I have done this
before with success but am now having trouble. The code below is the
function in the CFC. As you can see I am making this a facade to my
other CFCs. I am pretty sure that this should work but it isn't.

t.output.result = query, queryToXML outputs a valid xml object

I had to attach the CODE to a txt file.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Web Services

2004-08-25 Thread Ian Sheridan
I am having trouble with sending an xml doc to the user of my web
service. That user being me I am getting this error message:

Could not perform web service invocation getUsers because
java.lang.ClassCastException: java.lang.String

I transform a query to xml and the xml to a string. I have done this
before with success but am now having trouble. The code below is the
function in the CFC. As you can see I am making this a facade to my
other CFCs. I am pretty sure that this should work but it isn't.

t.output.result = query, queryToXML outputs a valid xml object

I had to place the CODE in a txt file, here is the link.

http://www.savagevines.com/stage/getUsers.txt

-- 

--
Ian Sheridan
http://www.savagevines.com
--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




OT: Oh brother

2004-08-25 Thread Ian Sheridan
sorry about the repeated posts.

I just started using Gmail and it was not showing up so... repeat

oops

-- 

--
Ian Sheridan
http://www.savagevines.com
--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Displaying commas and hyphens

2004-08-25 Thread Ian Sheridan
Steve,

Place them in a list and loop over the list. this way you only display
what is not NULL.

ex.

cfoutput
cfset Practice = john,jane,clyde,bobo,sammy,beth
pcfloop index=i from=1 to=#listlen(Practice)#cfif i GT 1,
/cfif#listgetat(Practice,i)#/cfloop/p
cfset Practice = john,,clyde,,sammy,
pcfloop index=i from=1 to=#listlen(Practice)#cfif i GT 1,
/cfif#listgetat(Practice,i)#/cfloop/p
/cfoutput

so you make the practice variable this:

cfset Practice =
#Practice1#,#Practice2#,#Practice3#,#Practice4#,#Practice5#,#Practice6#

Ian

--
Ian Sheridan
http://www.savagevines.com
--

- Original Message -
From: Steve Sawyer [EMAIL PROTECTED]
Date: Wed, 25 Aug 2004 23:37:36 -0400
Subject: Displaying commas and hyphens
To: CF-Talk [EMAIL PROTECTED]

This is going to be very basic...

 I want to display records with varying results, in this case
'Practice1', 'Practice2', €¦'Practice6'. However, not all members have
6 practices.

 I want each 'Practice' record separated by a comma, without out
displaying unnecessary commas. The following is definitely not the way
to go.Any suggestions?

 Thanks in advance.

 ul
 cfoutput query=GetMembers
tr
td height=20 colspan=5 align=left class=style2
 liA
HREF="">
#MI# #LName#/a - #Status#/li/td
/tr
tr
td height=20 colspan=5 align=left
class=style4#Practice1#, #Practice2#, #Practice3#, #Practice4#,
#Practice5#, #Practice6#/td
/tr
 /cfoutput
 /ul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Olympics web site - anyone know anything about how it's built?

2004-08-22 Thread Ian Sheridan
Well I'm in the US and I saw a hat that I liked in the 
http://eshop.athens2004.com/ shop (sorry not CF). 14.40 euros is no big 
deal so I wanted to buy it. To do that you have to register and I 
couldn't. It did not have USA listed in the country drop down. Is it 
me?! because I saw a bunch of other countries there that are not in the 
EU. It didn't list Canada either.

Sorry about being OT, I know that NBC (a television network here in the 
US) bought all the broadcasting rights to the Olympics but damn why 
can't my capitalist pig ass buy a darn hat?!heh

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF and Eclipse

2004-06-21 Thread Ian Sheridan
DL the FTP and WEBDAV plugin. it's a little tricky but basically you
deploy with FTP.

http://download.eclipse.org/downloads/drops/S-3.0RC2-200406111814/ 
index.php

scroll down you should see what you need.

I manage using the FTP deployment with import and export.

Hope that helps

Ian

On Jun 18, 2004, at 10:52 AM, John Beynon wrote:

 I've just put the new version on and the latest cfeclipse...i can see
 me
 switching to this as my preferred IDe very quickly...just need to
 figure out
 how to ftp from within eclipse - anyone?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Strange issue with large numbers

2004-06-15 Thread Ian Sheridan
The script bellow does not work right.

cfscript
	myone = toString(20031125160712114);
	mytwo = toString(20031125160712113);
	if (#mytwo# NEQ #myone#) {
		writeoutput(#myone# and #mytwo# are bnot/b the same);
	} else {
		writeoutput(#myone# and #mytwo# are the same);
	}
/cfscript

Try it out and you will see the output of the second writeoutput. We 
have tested this on CF 4.0 on up to 6.1 and it happens every time. yes 
there are unnecessary #'s and quote marks take them out and you will 
see the same issue.

So the question is: Is this a BUG? Can anyone enlighten me as to why 
this is happening?

Those numbers are record IDs from a database so they would have to be 
compared in this way.

Ian

- - - - - - - - - - - - - - -
Ian Sheridan
Time Warner Cable
1-212-379-5138 x85138
[EMAIL PROTECTED]
- - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Strange issue with large numbers

2004-06-15 Thread Ian Sheridan
Well we ended up using CONTAINS and DOES NOT CONTAIN and it seems work 
consistently. Well I think that this is an issue that should at lease, 
as you say, throw and exception.

On Jun 15, 2004, at 1:03 PM, Raymond Camden wrote:

 CF does have a concept of a maxint, the largest number it can hold
 correctly. Unfortunately when you run into this, you never get an 
 exception,
 you just get wierd behaviour. For example, dateDiff, when returning a 
 result
 that is too big, will simply roll over. I'm not quite sure what the 
 best way
 to handle this is.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: OT: MX2004 Tools and New OS X Update

2004-06-08 Thread Ian Sheridan
Simeon,

Your main issue is Permissions. you should try to run Repair 
Permissions again. also make sure that your account on the machine has 
Admin access (system preferences  accounts  security, it should say 
Admin under your account name). You most likely do have that type of 
access but just to make sure.

If that does not work you will have to go to the terminal (Applications 
  Utilities  Terminal [it's the command line]). Once there type this 
command:

sudo chown -R YourAccountName:staff /Applications/MacromediaDirectories/

You have to change YourAccountName to your account name (the *short 
name* under the System Pref / Accounts). And change 
MacromediaDirectories to the directory you have your MX stuff in. Do 
this for each directory.

This will do no harm. Good luck!

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

On Jun 7, 2004, at 10:11 PM, Jeff wrote:

 On 6/7/04 7:21 PM, Simeon Bateman [EMAIL PROTECTED] wrote:
 Has anybody else taken the update?Similiar problems?Anybody think 
 they
 might have a solution?I know this is off topic but this is the 
 biggest pool
 of Macromedia/OSX users i know of.None of my other applications are
 effected.

 Thanks for any help.
 simeon

 Hi Simeon. I came home today and installed the update on my Powerbook
 running 10.3.4, and I just checked, and all my Macromedia MX tools 
 work. I'm
 able to open up each one...sorry, wish I could help, but I've 
 installed the
 update, restarted, and everything is able to start okay...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFC problems

2004-06-08 Thread Ian Sheridan
Join the cfcdev list

http://www.cfczone.org/listserv.cfm


On Jun 8, 2004, at 1:23 PM, Cutter (CF-Talk) wrote:

 (Revised Repost) Does anyone have an example of a CFC used to
 instantiate an object. Something with a defined structure, get and
 set methods, etc. Someone suggested cfczone.org, but none of these
 that I have downloaded so far seem to be this type of object. Trying to
 figure out why mine doesn't seem to be working (first time with this
 type of usage, very frustrating at this point).

 Cutter



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: How do you *manage* time? (Add it, Subtract it, Track it)

2004-05-28 Thread Ian Sheridan
Jeff,

Think of it this way you want to keep the duration of how long a person 
worked separate from when they opened and closed the task. The reason 
being if the person opened the task this morning at 9:00am and closed 
it tomorrow evening at 5:00pm but only spent a total of 2.25 hrs 
actually doing the task. This separation lends itself to more 
flexible reporting.

So with this in mind you want to have a floating integer field and two 
date time fields. This way you will always know if a task is opened 
if the opened data time field is not NULL and the same goes for closed.

I always work with a base of hours and go up and down from there.

This is a little more then you asked but I hope it helps.

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

On May 28, 2004, at 9:49 AM, Jeff Small wrote:

 Okay, so let's say you're using SQL Server, and you want to create an
 application that was going to track time and do things like, eventually
 multiply hours by currency (hourly rate by 1 hour 45 minutes) and add
 several rows containing time to accumulate time spent, time remaining, 
 etc,
 and graphing it with CFChart (time spent vs time allocated), etc...

 How would you store it and manipulate it in CF?

 Do you store it as a DateTime object? What if you only add time on the 
 front
 end in fifteen minute increments (say, an hourdropdown with 1, 2, 
 3, 4,
 5, 6, 7, 8 and a minutes dropdown menu with 00, 15, 30, 45 so you
 could, say, select 4:45 to insert for your particular time entry) do 
 you
 use CF to create ODBC Date Time objects and pass those in, stored as a 
 Date
 Time object? But if you enter 4:45, how does it know you're adding a
 *quantity* of time, rather than just saying 4:45 this afternoon?

 So, how *do* you store times if you want to add them and have the math 
 work
 right?
 (For example (1:45 + 1:45)$10/hr = $35...like that)

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XPath Help

2004-05-21 Thread Ian Sheridan
I found this site to be an excellent eye opener for xPath.

http://www.zvon.org/xxl/XPathTutorial/General/examples.html

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XPath Help

2004-05-21 Thread Ian Sheridan
I shot that off to fast here is a more focused link. the site is a 
little confusing.

http://www.zvon.org/xxl/XPathTutorial/Output/example1.html

On May 21, 2004, at 7:56 AM, Ian Sheridan wrote:

 I found this site to be an excellent eye opener for xPath.

 http://www.zvon.org/xxl/XPathTutorial/General/examples.html

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-20 Thread Ian Sheridan
here is your answer:

cfscript
	var2 = ;
	n = listlen(var1);
	for (i=1;i LTE n;i=i+1) {
		curr = listgetat(var1,i);
		if (i LT n) {
			next = listgetat(var1,i + 1);
		} else {
			next = ;
		}
		if (i GT 1) {
			last = listgetat(var1,i - 1);
		} else {
			last = ;
		}
		if (curr + 1 NEQ next) {
			var2 = listappend(var2,i,-);
		} else if (curr - 1 NEQ last) {
			var2 = listappend(var2,i);
		}
	}
/cfscript

you had to look forward and back.

On May 20, 2004, at 9:36 AM, Nathan R. Jessop wrote:

 Hmm...


 If my var1 is equal to...

 cfset var1 = 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,
 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33,
 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67,
 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84,
 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100,
 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114,
 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128,
 129, 130


 I get this for the output:

 1

 It should be 1-130



 Still not quite right:

 initial : 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50
 desired : 1-6,10-14,20,25,30-33,50
 computed: 1-6,10-14,20-20,25-25,50
^^ ^^ ^^

 The code in my initial post works correctly, and is reposted (with
 slight
 optimizations) below:


 cfset var1 = 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50 /


 cfset last =  /
 cfset var2 =  /
 cfset startedRange = false /
 cfloop list=#var1# index=curr
 	cfif last EQ curr - 1
 		cfset startedRange = true /
 	cfelseif startedRange
 		cfset var2 = var2  -  last /
 		cfset startedRange = false /
 	/cfif
 	cfif NOT startedRange
 		cfset var2 = listAppend(var2, curr) /
 	/cfif
 	cfset last = curr /
 /cfloop

 Cheers,
 barneyb

 -Original Message-
 From: Steve Nelson [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, May 19, 2004 11:50 AM
 To: CF-Talk
 Subject: RE: **UPDATE** Arrange sequential selections into
 ranges how to???

 cfset var1 = 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50



 cfset var2=

 cfset lastitem=listfirst(var1)

 cfset groupstart=lastitem

 cfloop list=#var1# index=item

 cfif item gt lastitem+1

 cfif item is listlast(var1)

 cfset newgroup=item

 cfelse

 cfset
 newgroup=#groupstart#-#lastitem#

 /cfif

 cfset var2=listappend(var2,newgroup)

 cfset groupstart=item

 /cfif

 cfset lastitem=item

 /cfloop



 cfoutput#var2#/cfoutput



 I left out the lastitem=item



 Steve





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-20 Thread Ian Sheridan
OOPS

here is is fixed

cfscript
	var2 = ;
	n = listlen(var1);
	for (i=1;i LTE n;i=i+1) {
		curr = listgetat(var1,i);
		if (i LT n) {
			next = listgetat(var1,i + 1);
		} else {
			next = ;
		}
		if (i GT 1) {
			last = listgetat(var1,i - 1);
		} else {
			last = ;
		}
		if (curr - 1 NEQ last) {
			var2 = listappend(var2,listgetat(var1,i));
		} else if (curr + 1 NEQ next) {
			var2 = listappend(var2,listgetat(var1,i),-);
		}
	}
/cfscript

On May 20, 2004, at 10:07 AM, Ian Sheridan wrote:

 here is your answer:

 cfscript
 	var2 = ;
 	n = listlen(var1);
 	for (i=1;i LTE n;i=i+1) {
 		curr = listgetat(var1,i);
 		if (i LT n) {
 			next = listgetat(var1,i + 1);
 		} else {
 			next = ;
 		}
 		if (i GT 1) {
 			last = listgetat(var1,i - 1);
 		} else {
 			last = ;
 		}
 		if (curr + 1 NEQ next) {
 			var2 = listappend(var2,i,-);
 		} else if (curr - 1 NEQ last) {
 			var2 = listappend(var2,i);
 		}
 	}
 /cfscript

 you had to look forward and back.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-20 Thread Ian Sheridan
heh ok sorry here is the full script:

cfscript
	var1 = 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50;
	var2 = ;
	n = listlen(var1);
	for (i=1;i LTE n;i=i+1) {
		curr = listgetat(var1,i);
		if (i LT n) {
			next = listgetat(var1,i + 1);
		} else {
			next = ;
		}
		if (i GT 1) {
			last = listgetat(var1,i - 1);
		} else {
			last = ;
		}
		if (curr - 1 NEQ last) {
			var2 = listappend(var2,listgetat(var1,i));
		} else if (curr + 1 NEQ next) {
			var2 = listappend(var2,listgetat(var1,i),-);
		}
	}
/cfscript

!--- output ---
cfoutput
pre
initial : #var1#
desired : 1-6,10-14,20,25,30-33,50
computed: #var2#
/pre
/cfoutput

On May 20, 2004, at 10:48 AM, Nathan R. Jessop wrote:

 Where do I place this?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX doc root as a Mounted Volume

2004-05-19 Thread Ian Sheridan
Hey,

We are planing a cluster and we would like to place all our CFM/CFC 
files on a mounted volume so solve syncing. Can this work? and will 
there be any performance issues?

Ian

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX doc root as a Mounted Volume

2004-05-19 Thread Ian Sheridan
On May 19, 2004, at 10:11 AM, Thomas Chiverton wrote:

 On Wednesday 19 May 2004 15:06 pm, Ian Sheridan wrote:
 files on a mounted volume so solve syncing.

 It'll run fine. Just watch the CF user has suitable permissions.

 there be any performance issues?

 Network is slower than disk, so yes, some, but raise the number of 
 cached
 template files in the administrator to the number of templates in your 
 app
 and it'll be OK.

Well my next question is: If the file server goes down will CF continue 
to access the compiled versions?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Mihai Bazon ( mishoo ) website gone

2004-05-18 Thread Ian Sheridan
http://dynarch.com/mishoo/htmlarea.epl

On May 17, 2004, at 10:43 AM, mayo wrote:

 -Original Message-
 From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
 Sent: Monday, May 17, 2004 9:40 AM
 To: CF-TALK
 Subject: Mihai Bazon ( mishoo ) website gone


 Does anyone know what's happened to http://dynarch.com? I was going to
 purchase his htmlarea code and the site's been down since Thursday
 night.

 Is he still there?

 Gil Midonnet



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]