I was unfortunately told to finish the project NOW and be done withit, so I just removed the check.While I'd like to follow-through and learn something here, I was handed a different load to process for now.
Nonetheless, I want to thank everyone for replying and for the additional strategies.
I
hmm, I guess that's true. Still, I'd like to know why the IF
fails. I sometimes need to do a GT 0 to see if there're
duplicates and it'll fail then too.
I think you'd have to post your code in its entirety for me to be able to
answer that.
Dave Watts, CTO, Fig Leaf Software
An insert statement (which is what I assume you are doing) doesn't return a recordset.You might want to create a stored proc that returns an output param back to CF indicating that the insert either failed or succeeded.
HTH,
--
Jeff Garza
- Original Message -
From: daniel kessler
To:
Sorry, I should have put the query
An insert statement (which is what I assume you are doing) doesn't
return a recordset.
I am doing an insert, but I'm doing a Query after the insert to see if it's been added.In the code, add_check is the query name.Here's the query:
cfquery name=add_check
An insert statement (which is what I assume you are doing)
doesn't return a recordset.You might want to create a
stored proc that returns an output param back to CF
indicating that the insert either failed or succeeded.
Unless I'm missing something, this is needless complication. If the
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
_
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 1:19 PM
To: CF-Talk
Subject: Re: GT 0 failing CFIF decision
Sorry, I should have put the query
An insert statement (which is what I assume you are doi
Unless I'm missing something, this is needless complication. If the insert
fails, you'll get an error. If you don't get an error, the insert succeeded.
hmm, I guess that's true.Still, I'd like to know why the IF fails.I sometimes need to do a GT 0 to see if there're duplicates and it'll fail then
I would do cfif add_check.recordcount instead of cfif
add_check.recordcountGT 0 however the way you have should be
working unless maybe there is some other code you have not posted that
might apply to this.
You say it is failing, does it post an error or does it just always do the Else?
On Fri,
I saw something about this being a problem with MX6.1 that an updater
fixes... I'd check it out by googling and looking on live docs.
George
_
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Fri 7/30/2004 4:32 PM
To: CF-Talk
Subject: Re: GT 0 failing CFIF decision
I would do cfif
9 matches
Mail list logo