Post reply

Multiple inserts

  • August 5, 2005 at 2:06 pm

    #580173

    WOW!! just between a couple of back and forth I got too late

    You are really fast guys huh!

     


    * Noel

  • August 5, 2005 at 2:08 pm

    #580177

    Hey, I got nothing to do now... week-end starts in 7 minutes 45 seconds .

    ... And it took you 30 minutes to come back betwen replies .

  • August 5, 2005 at 2:09 pm

    #580178

    - I'm officially withdrawing from this post....I just CANNOT MATCH your typing speed!AAAARGH!

    - big K - oh thanks - you know how much arguing with you has helped the numbers right ?!

    I think now I am going to disappear and reemerge on this site as a genderneutral persona so no one can track me down anymore! That way I can skulk around and observe without being observed!!!







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 5, 2005 at 2:10 pm

    #580180

    True I am doing other stuff too

     


    * Noel

  • August 5, 2005 at 2:11 pm

    #580181

    Yup, you're on 2 threads right now, it's harder to keep up.

  • August 5, 2005 at 2:12 pm

    #580182

    No such thing for you any more! Are you changing the IP address too ?

    Besides your writting style will soon discover you

     


    * Noel

  • August 5, 2005 at 2:14 pm

    #580185

    Sushila,

     

    1) The five inserts you have to do!

    I have to insert data from 5 forms into 5 different tables. So one of the inserts would look like this:

    INSERT INTO School(UniqueId, SchoolName, SchoolCount, SchoolType, SchoolAdd1, SchoolAdd2, SchoolPhone, SchoolFax, SchoolIP, SchoolInfo, SchoolChart) VALUES(UniqueID, SchoolName, SchoolCount, etc....)

    2) any other common fields besides uniqueID ?! that'll certainly help reduce the # of parameters being passed.

    Unfortunately no, the data is related, but there is no data that is repeated across the tables.

    3) if there are no other common fields, then you just have to pass all 10-15 fields from each table as variables

    Yeah, fun.

    4) not sure what you mean by linking the tables - they're already being linked by uniqueid right ?!

    Yeah, I just mean I don't quite comprehend how I'll actually use UniqueId to link them.  Like how do I make sure each row in all 5 tables has the correct UniqueID?

    5) is your uniqueid an identity column that increments automatically or is it something you insert ?!

       Yeah, it's an identity column.  I could change that though since there's no real data in the tables yet.

    Thanks,

    M

  • August 5, 2005 at 2:15 pm

    #580188

    Yup, she's easy to spot. She's the one writting in correct english.

    Let the week-end start. L8r guys.

  • August 5, 2005 at 2:16 pm

    #580192

    Alright guys - it's a challenge - I'm NOT going to tell you before officially disappearing as Sushila and I'm obviously not going to tell you when I transition as whoever else - no - I cannot change my IP - but I CAN change my writing style - I'm looking forward to some fun and games (for me at least)....







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 5, 2005 at 2:16 pm

    #580189

    She meant, do you have relations between the tables?

  • August 5, 2005 at 2:19 pm

    #580194

    Ya but you'll lose the post count... so I don't see the point. You'll never be a carpal tunnel .

    OK. I'm realy, really gone now..................

  • August 5, 2005 at 2:22 pm

    #580197

    It is going to be even more fun! to bring you out of the shell!!


    * Noel

  • August 5, 2005 at 2:25 pm

    #580201

    magyar - noel has the stored procedure all practically written out for you...

    where he says:

    Select @UniqueId = Scope_Identity(), @Err =@@Error

    if @Err 0 Goto QuitWithRollback

    -- Now use the ID from above to the rest of the tables

    that's exactly what you do...you insert into the first table - grab the unique ID that will be generated by the insert and then insert this ID into all your other tables - there really is no more to it than what noel has already outlined!

    remi - who wants carpal tunnel when i can have the challenge of working my way up the ladder again - besides the fun is going to be in the lurking!

    hasta lunes noel!







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 5, 2005 at 2:47 pm

    #580206

    M,

    Sorry for the delay getting back to you - darn paying job keeps interupting!!

    sushila - I agree wholeheartedly!!!!

    Looks like you folks have about solved the problem so I am off to the next task - getting ready for the weekend!!!!

     

    Darrell

  • August 5, 2005 at 5:37 pm

    #580217

    M,

    Store the values as either session variables in ASP or state variables in ASP.NET.  (I'm assuming you are using ASP).  Once the 5th page is submitted then update your tables via a stored procedure. 

    Marvin

    Marvin Dillard
    Senior Consultant
    Claraview Inc

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

You must be logged in to reply to this topic. Login to reply