Try something like this:
Create Procedure UserCheck
@Entry int
@Return int
AS
IF @Entry = 1
Begin
Update Users
Set 1 = @Return
Where ID = 1
End
Else IF @Entry = 2
Begin
Update Users
Set 2 = @Return
Where ID = 1
End
and then to call the procedure in CF:
<cfquery name="" datasource="">
execute UserCheck @Entry = #entry#,@Return = #return#
</cfquery>
HTH
--
Clint Tredway
www.factorxsoftware.com
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
