If _all_ children _aways_ get published (like your pseudocode indicates),
why not just flag the parent category?
If you want to do it all in SQL, try...
http://msdn.microsoft.com/en-us/library/ms186243.aspx
Jason Durham
On Fri, Jan 28, 2011 at 1:16 AM, wabba must...@wabba.net wrote:
Hi
I've been trying to figure this one out. The query gets hit, but the
database isn't being updated from the values in the form. The columns seem
valid, and the table permissions are fine.
What does your debug output show?
Are you setting the form variable used in the WHERE clause?
Dave
Run:
SELECT * FROM dbo.Vehicles WHERE (StockNo='#form.carid#')
and see if that returns a row.
On Tue, Feb 3, 2009 at 6:34 PM, Rick Sanders r...@webenergy.ca wrote:
I've been trying to figure this one out. The query gets hit, but the
database isn't being updated from the values in the form.
.
This is a weird one!
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: February-03-09 8:39 PM
To: cf-talk
Subject: Re: No SQL Update!
I've been trying to figure this one out. The query gets hit, but the
database isn't being updated from the values in the form
What do you get when you run:
SELECT *
FROM dbo.Vehicles
WHERE (StockNo='3')
~Brad
Original Message
Subject: RE: No SQL Update!
From: Rick Sanders c...@webenergy.ca
Date: Tue, February 03, 2009 6:46 pm
To: cf-talk cf-talk@houseoffusion.com
StockNo is a char/varchar datatype?
On Tue, Feb 3, 2009 at 4:55 PM, b...@bradwood.com wrote:
What do you get when you run:
SELECT *
FROM dbo.Vehicles
WHERE (StockNo='3')
~Brad
Original Message
Subject: RE: No SQL Update!
From: Rick Sanders c...@webenergy.ca
Date
[mailto:charlie.grie...@gmail.com]
Sent: February-03-09 9:02 PM
To: cf-talk
Subject: Re: No SQL Update!
StockNo is a char/varchar datatype?
On Tue, Feb 3, 2009 at 4:55 PM, b...@bradwood.com wrote:
What do you get when you run:
SELECT *
FROM dbo.Vehicles
WHERE (StockNo='3')
~Brad
Original
no wonder why it didn't
update.
Time to step away from the puter. Thanks for listening!
-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
Sent: February-03-09 9:02 PM
To: cf-talk
Subject: Re: No SQL Update!
StockNo is a char/varchar datatype?
On Tue, Feb
Even a nickel and I'd be happy!
-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
Sent: February-03-09 9:17 PM
To: cf-talk
Subject: Re: No SQL Update!
yeah, that's one of those if i only had a dollar for every time... things
:)
On Tue, Feb 3, 2009 at 5:14 PM
Thank you Paul and Nate.
Dan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Is there a way to detect if a SQL update statement in CFQUERY resulted
in a record being updated? I guess I would want to know the number of rows
updated.
depends on your db, for sql server examine the @@ROWCOUNT var immediately
after your update.
[Todays Threads]
[This Message]
it helps,
Nate Nelson
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 4:58 PM
To: CF-Talk
Subject: Re: Detecting SQL Update success
Is there a way to detect if a SQL update statement in CFQUERY
resulted
in a record being updated? I
Hi,
Could someone tell me where I'm going wrong with the below cfquery?
cfquery name=qUpdateProfile datasource=prefs
UPDATE tblProfiles
(
strSelect,
strShowMe
)
VALUES
(
cfqueryparam value=#No_Access_List#
Hi,
Could someone tell me where I'm going wrong with the below
cfquery?
cfquery name=qUpdateProfile datasource=prefs
UPDATE tblProfiles
(
strSelect,
strShowMe
)
VALUES
(
cfqueryparam value=#No_Access_List#
cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam
dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 12:52 PM
To: CF-Talk
Subject: re: MS SQL UPDATE syntax help
Hi,
Could someone tell me where I'm going wrong with the below cfquery
heh
looks like an INSERT query to me ;)
try
UPDATE tblProfiles
Set blah = blah,
blah2 = blah2
where blah = blah
cheers
- Original Message -
From: Bushy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 9:51 AM
Subject: re: MS SQL UPDATE syntax help
If there is a variables called #active_week# and you have it in a cfquery
you don't need a tag around it.
Ade
-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
Sent: 01 August 2003 16:41
To: CF-Talk
Subject: dynamic sql update
i know i need a tag around
17 matches
Mail list logo