Forum Replies Created

Viewing 15 posts - 181 through 195 (of 217 total)

  • RE: SELECT from multiple tables

    Govinn,

    Thank you for your reply.  However, this won't work, because there is no relation between the clientmaster and dmvrequest table.

    Now you may ask, then why am I doing this.  I'm...

  • RE: Multiple inserts

    sushila 

    Forgive my ignorance, but how do I tell the stored procedure what variable goes where?  Right now, I just my variables defined...

  • RE: Multiple inserts

    I don't think I can do this in ASP, because I'd have to pass the variables like so:

    'all the variables from all the forms

    SchoolName = SchoolName      

    SchoolCounty = SchoolCounty

    SchoolType=SchoolType

    etc....

    set dataConn = Server.CreateObject("ADODB.Connection")

    dataConn.Open ...

  • RE: Multiple inserts

    Remi,

    Oh yeah, thanks.

    BTW...why would I do all the inserts in the stored procedure? 

    My issue with this is, how the heck would I...

  • RE: Multiple inserts

    Thank you for all your help guys,

    When creating the stored procedure, won't I need to do something like:

    create procedure prc_modulename_insertbig (

    @SchoolName       varchar(50),

    @SchoolCounty      varchar(50),

    @SchoolType       char(1),

    @SchoolAdd1        varchar(100),

    @SchoolAdd2       varchar(100),

    @SchoolPhone      char(11),

    @SchoolFax          char(11),

    @SchoolIP           ...

  • RE: Multiple inserts

    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,...

  • RE: Multiple inserts

     

    Even if I do somehow manage to write the stored procedure, how do I handle to uniqueid?  How do I link all the tables together?

     

     

  • RE: Multiple inserts

    Thank yous

    Ok , I can do an insert, and I can put together an error check, but how would I handle the UniqueId that servers as the key to link...

  • RE: Multiple inserts

     

    It sounds beautiful...but also extremely difficult.  I wouldn't even know where to start!

     

     

  • RE: Multiple inserts

    DSP,  I agree with you on the first step; I will do the INSERT on the last page.

    As far as table structure goes, I have 5 tables: School, Students, Professors,...

  • RE: Combining SELECT statements

     

    Thanks for all your help Remi. 

  • RE: Combining SELECT statements

    I think I got it working:

    strSQL="SELECT SQ.*, DEdescription, DEenteredDate

     , ST.AOcontactNameLast AS SendTo

     , BT.AOcontactNameLast AS BillTo

     , R.AOcontactNameLast AS Requestor

     , DE.*" &_

    FROM schoolrequest SQ" &_

     LEFT JOIN academicoffice ST ON SQ.SLsendToId=ST.AOid

     LEFT JOIN academicoffice...

  • RE: Combining SELECT statements

     

    I'm still going for it...although I'm thinking of splitting the one query into two.  So the first one would be:

     

    SELECT SQ.*

     , ST.AOcontactNameLast AS SendTo

     , BT.AOcontactNameLast AS BillTo

     , R.AOcontactNameLast AS Requestor

     ,...

  • RE: Combining SELECT statements

    SLFine,

    I think my biggest issue now is that I felt as if I was getting somewhere(with Remi's invaluable guidance) with the original query, but now I'm totally lost as what...

  • RE: Combining SELECT statements

     

    The form is just one form though.  It has maybe 15 total fields and pulls information from three tables.  I don't understand what is wrong with that.  All the data...

Viewing 15 posts - 181 through 195 (of 217 total)