[cfaussie] Re: UML Tool

2007-10-10 Thread Pat Branley

This is my fav:

http://qse.ifs.tuwien.ac.at/~auer/umlet/

Just lets you draw diagrams and save them to PDF, JPG or SVG. Better
than a napkin, not quite as good as full CASE tool.

If i want anything more formal where im using the CASE tool for
keeping track of the design then i use Visio or argoUML

Pat




On Oct 10, 12:52 pm, Andrew Scott [EMAIL PROTECTED]
wrote:
 There are many free Eclipse plugins for UML, worth a look.

 On 10/10/07, Dale Fraser [EMAIL PROTECTED] wrote:





  Any recommendations for a UML tool?

  Preferably free.

  Regards

  Dale Fraser

 http://learncf.com

 --

 Senior Coldfusion Developer
 Aegeon Pty. Ltd.www.aegeon.com.au
 Phone: +613  8676 4223
 Mobile: 0404 998 273


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: installing CF8 on Apache 2.2.6 (Win32) connector woes

2007-10-10 Thread Barry Beattie

at least I've narrowed it down to not being an Apache problem - IIS
has exactly the same issues.

and it can't be a CF8 problem because every man and his dog was a beta
tester, esp for something this simple.

no, everything points to firewall blocking port 51800 - on this dev
box. and yet the local firewall isn't running...

times like this make me appreciate Mac's...



On 10/9/07, Barry Beattie [EMAIL PROTECTED] wrote:
 just setting up a dev box...

 the last build (2.2.6) for Apache (Win32 - WinXP) installed nicely

 but when installing CF8...

 the basic install went OK, but it wouldn;t connect to the Apache webserver.

 researching this problem hasn't shown anything up

 yes, I have got local admin
 yes, local Firewall is turned off so access to port 51800 shouldn;t be
 a problem.

 below is the connector0.bat file used to run the connector set-up. It
 should work, the only thing I can think of is Apache 2.2.6 came out in
 September after CF8 (but 2.2.6 was ajust a bug fix anyway)

 any suggestions?
 thanx
 barry.b

 echo off
 cd C:\ColdFusion8\runtime\lib
 C:\ColdFusion8\runtime\jre\bin\javaw.exe -Dtrace.ci=1 -jar
 wsconfig.jar -server coldfusion -ws apache -dir C:/Program
  Files/Apache Software Foundation/Apache2.2/conf -bin C:\Program
 Files\Apache Software Foundation\Apache2.2\bin\httpd.exe

 -coldfusion -v


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Seona Bellamy
Oh yeah! Thanks. :)

*slaps forehead and walks away muttering about forests and trees*

On 11/10/2007, Blair McKenzie [EMAIL PROTECTED] wrote:

 select * from yourquery where primarykey not in (list,of,items,to,remove)

 Blair

 On 10/11/07, Seona Bellamy  [EMAIL PROTECTED] wrote:
 
  Heya,
 
  Working with a large cached query here (it's used several different
  times on the page in several different ways, so we've cached the whole big
  query and then just perform QoQ's on it to get the various sub-sets we
  need). I've run into a situation where I want to be able to selectively
  remove certain records from the recordset under specific circumstances.
 
  Is this possible? I thought there might have been a function to do it,
  along the lines of queryAddRow(), but there doesn't seem to be. Anyone ever
  done this before?
 
  Any advice would be appreciated.
 
  Cheers,
 
  Seona.
 
 
 

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Is there a delete version of queryAddRow()?

2007-10-10 Thread Seona Bellamy
Heya,

Working with a large cached query here (it's used several different times on
the page in several different ways, so we've cached the whole big query and
then just perform QoQ's on it to get the various sub-sets we need). I've run
into a situation where I want to be able to selectively remove certain
records from the recordset under specific circumstances.

Is this possible? I thought there might have been a function to do it, along
the lines of queryAddRow(), but there doesn't seem to be. Anyone ever done
this before?

Any advice would be appreciated.

Cheers,

Seona.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Blair McKenzie
select * from yourquery where primarykey not in (list,of,items,to,remove)

Blair

On 10/11/07, Seona Bellamy [EMAIL PROTECTED] wrote:

 Heya,

 Working with a large cached query here (it's used several different times
 on the page in several different ways, so we've cached the whole big query
 and then just perform QoQ's on it to get the various sub-sets we need). I've
 run into a situation where I want to be able to selectively remove certain
 records from the recordset under specific circumstances.

 Is this possible? I thought there might have been a function to do it,
 along the lines of queryAddRow(), but there doesn't seem to be. Anyone ever
 done this before?

 Any advice would be appreciated.

 Cheers,

 Seona.

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Barry Beattie
Query'o;Query

o how I hate this horrible hack for deletes and updates (but there's no
choice)

I've suggested this for the CF9 wish list - native SQL syntax to do this.

and updates to (otherwise you delete then addRow with new values)

feel free to do the same

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform






On 10/11/07, Seona Bellamy [EMAIL PROTECTED] wrote:

 Oh yeah! Thanks. :)

 *slaps forehead and walks away muttering about forests and trees*

 On 11/10/2007, Blair McKenzie  [EMAIL PROTECTED] wrote:
 
  select * from yourquery where primarykey not in
  (list,of,items,to,remove)
 
  Blair
 
  On 10/11/07, Seona Bellamy  [EMAIL PROTECTED] wrote:
  
   Heya,
  
   Working with a large cached query here (it's used several different
   times on the page in several different ways, so we've cached the whole big
   query and then just perform QoQ's on it to get the various sub-sets we
   need). I've run into a situation where I want to be able to selectively
   remove certain records from the recordset under specific circumstances.
  
   Is this possible? I thought there might have been a function to do it,
   along the lines of queryAddRow(), but there doesn't seem to be. Anyone 
   ever
   done this before?
  
   Any advice would be appreciated.
  
   Cheers,
  
   Seona.
  
  
  
 
 
 

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: UML Tool

2007-10-10 Thread Dale Fraser

Thanks,

For anyone interested, this flash one is very nice.

http://www.gskinner.com/gmodeler/launch.html

Regards
Dale Fraser

http://learncf.com

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Pat Branley
Sent: Wednesday, 10 October 2007 5:45 PM
To: cfaussie
Subject: [cfaussie] Re: UML Tool


This is my fav:

http://qse.ifs.tuwien.ac.at/~auer/umlet/

Just lets you draw diagrams and save them to PDF, JPG or SVG. Better
than a napkin, not quite as good as full CASE tool.

If i want anything more formal where im using the CASE tool for
keeping track of the design then i use Visio or argoUML

Pat




On Oct 10, 12:52 pm, Andrew Scott [EMAIL PROTECTED]
wrote:
 There are many free Eclipse plugins for UML, worth a look.

 On 10/10/07, Dale Fraser [EMAIL PROTECTED] wrote:





  Any recommendations for a UML tool?

  Preferably free.

  Regards

  Dale Fraser

 http://learncf.com

 --

 Senior Coldfusion Developer
 Aegeon Pty. Ltd.www.aegeon.com.au
 Phone: +613  8676 4223
 Mobile: 0404 998 273



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Session Variables Stopped Working

2007-10-10 Thread Dale Fraser
I have an app that was working yesterday and isn't today.

 

I've pinned it down to session variables not working.

 

I've checked the admin settings and restarted cf but still nothing.

 

Take this example.

 

cfif isDefined(session.me)

 cfoutput#session.me#/cfoutput

cfelse

 Not Defined!

cfdump var=#COOKIE# /

/cfif

cfset session.me = now() /

 

I get the Not Defined, when refreshing the page.

 

CFID and CFTOKEN does exist in the COOKIE dump and remain consistant across
page refreshes.

 

Anyone have a clue?

 

 

Regards

Dale Fraser

 

http://learncf.com

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread paulineb

I had a similar thing happen yesterday. I think my instance restarted
itself and suddenly session variables weren't working. Our resident
guru said to click Use J2EE session variables in CF Admin which
apprently is not enabled by default when the server/instance starts


On Oct 11, 1:29 pm, Dale Fraser [EMAIL PROTECTED] wrote:
 I have an app that was working yesterday and isn't today.

 I've pinned it down to session variables not working.

 I've checked the admin settings and restarted cf but still nothing.

 Take this example.

 cfif isDefined(session.me)

  cfoutput#session.me#/cfoutput

 cfelse

  Not Defined!

 cfdump var=#COOKIE# /

 /cfif

 cfset session.me = now() /

 I get the Not Defined, when refreshing the page.

 CFID and CFTOKEN does exist in the COOKIE dump and remain consistant across
 page refreshes.

 Anyone have a clue?

 Regards

 Dale Fraser

 http://learncf.com


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread Andrew Scott
Dale,

 

Might be a stupid question, but is JSessionId switched on? That can have the
same effect you are talking about.

 



Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

 

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Thursday, 11 October 2007 1:29 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Session Variables Stopped Working

 

I have an app that was working yesterday and isn't today.

 

I've pinned it down to session variables not working.

 

I've checked the admin settings and restarted cf but still nothing.

 

Take this example.

 

cfif isDefined(session.me)

 cfoutput#session.me#/cfoutput

cfelse

 Not Defined!

cfdump var=#COOKIE# /

/cfif

cfset session.me = now() /

 

I get the Not Defined, when refreshing the page.

 

CFID and CFTOKEN does exist in the COOKIE dump and remain consistant across
page refreshes.

 

Anyone have a clue?

 

 

Regards

Dale Fraser

 

http://learncf.com

 



 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread Andrew Scott

When you use J2EE session variables, this forces CF to expire the session
after each page request. As opposed to using the standard CFID  CFToken.

When using the J2EE session variables, you have to rewrite your applications
to be persistant with that ID rather than the normal cookies, or use a REST
methodology to handle the expired sessions.


Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of paulineb
Sent: Thursday, 11 October 2007 1:36 PM
To: cfaussie
Subject: [cfaussie] Re: Session Variables Stopped Working


I had a similar thing happen yesterday. I think my instance restarted
itself and suddenly session variables weren't working. Our resident
guru said to click Use J2EE session variables in CF Admin which
apprently is not enabled by default when the server/instance starts


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread Andrew Scott

Dale,

The only other thing I can think of is that the application name doesn't
exist for some reason, I can't think of any other reason why you are
experiencing this problem.



Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273



-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Thursday, 11 October 2007 1:50 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Session Variables Stopped Working


Those two comments kinda contradict each other.

Use J2EE session variables was off and as far as I know is off by default
and has always been off.

I tried turning it on and it made no difference other than getting a
jsessionid in my cookie dump

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Thursday, 11 October 2007 1:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Session Variables Stopped Working


When you use J2EE session variables, this forces CF to expire the session
after each page request. As opposed to using the standard CFID  CFToken.

When using the J2EE session variables, you have to rewrite your applications
to be persistant with that ID rather than the normal cookies, or use a REST
methodology to handle the expired sessions.


Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of paulineb
Sent: Thursday, 11 October 2007 1:36 PM
To: cfaussie
Subject: [cfaussie] Re: Session Variables Stopped Working


I had a similar thing happen yesterday. I think my instance restarted
itself and suddenly session variables weren't working. Our resident
guru said to click Use J2EE session variables in CF Admin which
apprently is not enabled by default when the server/instance starts





--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread Dale Fraser

Ok,

I'm an idiot.

I removed Engine from application the other day, thus every request was
clearing session. I didn't realise however as the application hadn't
restarted thus application.Engine did still exist.

cffunction name=onRequestStart returntype=boolean output=true
cfif not isDefined(application.Engine) or isDefined(url.reload)
cfset structClear(session) /
/cfif

Thanks.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Thursday, 11 October 2007 1:50 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Session Variables Stopped Working


Those two comments kinda contradict each other.

Use J2EE session variables was off and as far as I know is off by default
and has always been off.

I tried turning it on and it made no difference other than getting a
jsessionid in my cookie dump

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Thursday, 11 October 2007 1:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Session Variables Stopped Working


When you use J2EE session variables, this forces CF to expire the session
after each page request. As opposed to using the standard CFID  CFToken.

When using the J2EE session variables, you have to rewrite your applications
to be persistant with that ID rather than the normal cookies, or use a REST
methodology to handle the expired sessions.


Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of paulineb
Sent: Thursday, 11 October 2007 1:36 PM
To: cfaussie
Subject: [cfaussie] Re: Session Variables Stopped Working


I had a similar thing happen yesterday. I think my instance restarted
itself and suddenly session variables weren't working. Our resident
guru said to click Use J2EE session variables in CF Admin which
apprently is not enabled by default when the server/instance starts




--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread paulineb

Andrew,

Do you mean when the browser is closed rather than after each page
request? I have J2EE session vars switched on and they only expire
after the browser is closed.

On Oct 11, 1:42 pm, Andrew Scott [EMAIL PROTECTED] wrote:
 When you use J2EE session variables, this forces CF to expire the session
 after each page request. As opposed to using the standard CFID  CFToken.



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Session Variables Stopped Working

2007-10-10 Thread Andrew Scott

Yes, when the browser is closed. Sorry for the confusion




Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273



-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of paulineb
Sent: Thursday, 11 October 2007 2:06 PM
To: cfaussie
Subject: [cfaussie] Re: Session Variables Stopped Working


Andrew,

Do you mean when the browser is closed rather than after each page
request? I have J2EE session vars switched on and they only expire
after the browser is closed.

On Oct 11, 1:42 pm, Andrew Scott [EMAIL PROTECTED] wrote:
 When you use J2EE session variables, this forces CF to expire the session
 after each page request. As opposed to using the standard CFID  CFToken.





--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Charles Condon
I came across this a while ago
http://www.bennadel.com/blog/204-Using-ColdFusion-Query-s-Underlying-Java-Methods-For-Query-Manipulation-And-Logic.htm


On 10/11/07, Barry Beattie [EMAIL PROTECTED] wrote:

 Query'o;Query

 o how I hate this horrible hack for deletes and updates (but there's
 no choice)

 I've suggested this for the CF9 wish list - native SQL syntax to do this.

 and updates to (otherwise you delete then addRow with new values)

 feel free to do the same

 http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform






 On 10/11/07, Seona Bellamy [EMAIL PROTECTED] wrote:
 
  Oh yeah! Thanks. :)
 
  *slaps forehead and walks away muttering about forests and trees*
 
  On 11/10/2007, Blair McKenzie  [EMAIL PROTECTED] wrote:
  
   select * from yourquery where primarykey not in
   (list,of,items,to,remove)
  
   Blair
  
   On 10/11/07, Seona Bellamy  [EMAIL PROTECTED] wrote:
   
Heya,
   
Working with a large cached query here (it's used several different
times on the page in several different ways, so we've cached the whole 
big
query and then just perform QoQ's on it to get the various sub-sets we
need). I've run into a situation where I want to be able to selectively
remove certain records from the recordset under specific circumstances.
   
Is this possible? I thought there might have been a function to do
it, along the lines of queryAddRow(), but there doesn't seem to be. 
Anyone
ever done this before?
   
Any advice would be appreciated.
   
Cheers,
   
Seona.
   
   
   
  
  
  
 
 
 

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Andrew Scott
But also take into consideration, that these are internal methods to
coldfusion an may become obsolete or changed.

 

I was trying to recall what the delete row was, as I have used it before but
couldn't recall where I had used itL



Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

 

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charles Condon
Sent: Thursday, 11 October 2007 3:16 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Is there a delete version of queryAddRow()?

 

I came across this a while ago
http://www.bennadel.com/blog/204-Using-ColdFusion-Query-s-Underlying-Java-Me
thods-For-Query-Manipulation-And-Logic.htm 



On 10/11/07, Barry Beattie [EMAIL PROTECTED] wrote:

Query'o;Query 

o how I hate this horrible hack for deletes and updates (but there's no
choice)

I've suggested this for the CF9 wish list - native SQL syntax to do this.

and updates to (otherwise you delete then addRow with new values) 

feel free to do the same

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform
http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform 









On 10/11/07, Seona Bellamy [EMAIL PROTECTED] wrote:

Oh yeah! Thanks. :)

*slaps forehead and walks away muttering about forests and trees*

 

On 11/10/2007, Blair McKenzie  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
wrote:

select * from yourquery where primarykey not in (list,of,items,to,remove) 

Blair

 

On 10/11/07, Seona Bellamy  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
wrote:

Heya,

Working with a large cached query here (it's used several different times on
the page in several different ways, so we've cached the whole big query and
then just perform QoQ's on it to get the various sub-sets we need). I've run
into a situation where I want to be able to selectively remove certain
records from the recordset under specific circumstances. 

Is this possible? I thought there might have been a function to do it, along
the lines of queryAddRow(), but there doesn't seem to be. Anyone ever done
this before?

Any advice would be appreciated.

Cheers,

Seona.



 

 













--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---