Nuts

[emmim44]

Hi all. The logic I am trying to implement is not working properly.Could you check my code ? It dropped me nut..

[Newsgroup_User]

please do describe your attempted logic in plain English - not many
people have the time to go through all that code of yours and try to
FIGURE OUT your logic and then figure out what's wrong with it... well,
at least i don;t have that much time...

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[emmim44]

That is not helpful. I couldnt figure out that is why I am posting here.

[cf_dev2]

> That is not helpful.

Seriously neither is posting 100+ lines of code with a note that "its not working properly". How do you expect people to know what the code IS suppposed to be doing unless you give a description of the desired results and the problem? Put a little effort into it.

[emmim44]

I assume all of you as a genius. :D

It fixed..
<cfset q = snum1 - 1>
<cfif s1.msnum eq 2>
<cfquery name="upt2" dataSource="#FormVector#">
update genbid_login1 set snum = snum -1
where status = 'A' and role = 'LT'
</cfquery>
<cfelseif q lt s1.mxsnum and snum1 gte 1>
<cfquery name="upt2" dataSource="#FormVector#">
update genbid_login1 set snum = snum -1
where snum > #q# and status = 'A' and role = 'LT'
</cfquery>
<cfelseif snum1 eq s1.mxsnum>

<cfquery name="upt2" dataSource="#FormVector#">
update genbid_login1 set snum = snum -1
where snum = #s1.mxsnum# and status = 'A' and role = 'LT'
</cfquery>

</cfif>