/****** Object:  Stored Procedure dbo.ujo_glob_set    Script Date: 12/1/2005 11:49:50 PM ******/

create proc ujo_glob_set
    @glo_name     varchar(64),
    @value        varchar(100),
    @value_set_time    int
AS

IF @value = 'DELETE'
BEGIN
    DELETE    ujo_glob
    WHERE    glo_name = @glo_name
    return 1
END


IF NOT EXISTS ( select glo_name from ujo_glob where glo_name = @glo_name )
BEGIN
    /* First time in - do an INSERT */
    INSERT ujo_glob ( glo_name, value, value_set_time )
    VALUES    ( @glo_name, @value, @value_set_time )

    return 1
END

/* Do an update */

UPDATE    ujo_glob
SET    value = @value,
    value_set_time = @value_set_time
WHERE    glo_name = @glo_name

return 1
GO
GRANT EXECUTE ON  [dbo].[ujo_glob_set] TO [ujoadmin]
GO