Forum Replies Created

Viewing 15 posts - 16 through 30 (of 40 total)

  • RE: Full Text Search works with numbers?

    Hi Adi, thanks for the quick reply

    But even that '1' (in my example) is a noise word, the fts should return me all the "company xpto" ... am i...

  • RE: insert multiple times...

    Christopher Stobbs (11/19/2008)


    IS this working with the change to the insert statement yet?

    Hello again,

    No is not, unfortunalty...

  • RE: insert multiple times...

    Hello again,

    First to Ninja's_RGR'us:

    We try this

    begin tran

    insert into table (columns) Select columns, parameters where not exists (check exists on base table here)

    commit tran

    and the same thing happens, few less times,...

  • RE: insert multiple times...

    Hi again,

    How are u since yesterday 🙂

    With the trans in the places the duplicate rows still appear...

  • RE: insert multiple times...

    Hi again,

    How are u since yesterday 🙂

    With the trans in the places the duplicate rows still appear...

  • RE: insert multiple times...

    Before i test ur new tip ( and i have to thanks again, for dont give up 🙂 ), we put the begin trans in the beginiing of the procedure......

  • RE: insert multiple times...

    yes i try with the altered insert... but same thing occours...

    declare @p21 int

    set @p21=1

    declare @p22 int

    set @p22=4135805

    exec CentralSaveContactPoint @form=4,@Name=N'José XXXX',@Phone=N'xxxxxxx',

    @Email=N'jxxxxxxx9@gmail.com',@Obs=N'comments',@Portal=1,@Origin=0,@EstateID=741636,

    @Business=0,@Nature=0,@PropType=0,@Town=0,@MaxPrice=0,@ClientID=0,@BPI=0,@Lang=0,

    @FoundInPage=0,@TotalPages=0,@FromWhere=1,@UserIP=N'00.000.000.00',

    @RowCount=@p21 output,@ScopeIdentity=@p22 output

    select @p21, @p22

    go

    declare @p21 int

    set @p21=1

    declare @p22...

  • RE: insert multiple times...

    i put the profiler running and i catch another duplicated insert...

    declare @p21 int

    set @p21=1

    declare @p22 int

    set @p22=4135805

    exec CentralSaveContactPoint @form=4,@Name=N'José XXXX',@Phone=N'xxxxxxx',@Email=N'jxxxxxxx9@gmail.com',@Obs=N'comments',@Portal=1,@Origin=0,@EstateID=741636,@Business=0,@Nature=0,@PropType=0,@Town=0,@MaxPrice=0,@ClientID=0,@BPI=0,@Lang=0,@FoundInPage=0,@TotalPages=0,@FromWhere=1,@UserIP=N'00.000.000.00',@RowCount=@p21 output,@ScopeIdentity=@p22 output

    select @p21, @p22

    go

    declare @p21 int

    set @p21=1

    declare @p22...

  • RE: insert multiple times...

    Hello again,

    no worries for the replies... ehehe, i was looking, and no parameter can be null, the maximum is '' 🙂

    I understand what u said on the last reply, but...

  • RE: insert multiple times...

    Hi again,

    i can't see where that appears, can u tell me here in sp?

    Regards

  • RE: insert multiple times...

    Hello Chris, first of all, i want to thank you for keeping help me...

    CREATE PROCEDURE [dbo].[CentralCheckDuplicate]

    @NameAS VARCHAR(4000),

    @PhoneAS VARCHAR(4000),

    @EmailAS VARCHAR(4000),

    @ObsAS VARCHAR(4000),

    @EstateIDAS INT

    AS

    SET NOCOUNT ON

    --IF(EXISTS(SELECT ID FROM CONTACTS WHERE [NAME]=@Name...

  • RE: insert multiple times...

    Hi again,

    I see now that the problem is that in sometimes the app call the sp two times, but even in that way, the database shouldnt let the row be...

  • RE: insert multiple times...

    Just when the sp is run from app...

  • RE: insert multiple times...

    hi,

    There is no trigger here, this sp is called from application, but even if the sp is called 2 times, i have a validation in sp that checks if there...

  • RE: insert multiple times...

    CREATE PROCEDURE [dbo].[xxxx]

    @formAS INT,

    @NameAS VARCHAR(4000),

    @PhoneAS VARCHAR(4000),

    @EmailAS VARCHAR(4000),

    @ObsAS VARCHAR(4000),

    @PortalAS INT,

    @OriginAS INT,

    @EstateIDAS INT,

    @BusinessAS INT,

    @NatureAS INT,

    @PropTypeAS INT,

    @TownAS INT,

    @MaxPriceAS MONEY,

    @ClientIDAS INT,

    @BPIAS INT,

    @LangAS INT,

    @FoundInPageAS INT,

    @TotalPagesAS INT,

    @FromWhereAS INT,

    @UserIPAS VARCHAR(4000),

    @neighborhoodAS VARCHAR(4000)...

Viewing 15 posts - 16 through 30 (of 40 total)