Results 1 to 11 of 11
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: HELP on How Create a STORED PROCEDURE

    I've these tables:

    CREATE TABLE TABX_TO_TABY
    (
    COD_ID VARCHAR2(32),
    CID VARCHAR2(32),
    NAME_FIRST VARCHAR2(32),
    NAME_LAST VARCHAR2(32),
    EMAIL VARCHAR2(32),
    MOBILE VARCHAR2(32),
    STAT VARCHAR2(32)
    );

    ALTER TABLE TABX_TO_TABY
    ADD (CONSTRAINT PK_COD_ID PRIMARY KEY (COD_ID));


    CREATE TABLE TABY
    (
    PK_ID VARCHAR2(32),
    COD_ID VARCHAR2(32),
    NAME_FIRST VARCHAR2(32),
    NAME_LAST VARCHAR2(32),
    EMAIL VARCHAR2(32),
    CITY VARCHAR2(32),
    MOBILE VARCHAR2(32),
    STAT VARCHAR2(32)
    );

    ALTER TABLE TABY
    ADD (CONSTRAINT PK_PK_ID PRIMARY KEY (PK_ID));

    The primary key PK_ID comes from the TABX_TO_TABY table linked in this way:
    name_last||'_'||substr(name_first,1,3)||'_'||subst r(cod_id,-3)


    TABX_TO_TABY has more 10000 records
    TABY has more 5000 records

    Below is a subset of data:

    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('00123', NULL, 'TOMMY', 'MAL','mal2@bb.com', '333345698756', '1');
    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('00127', '00999', 'SAMMY', 'LUISS', 'cccc@bb.com', '97979799333', '1');
    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('22129', NULL, 'GRACE', 'LUISS', 'mmmm@bb.com', '3443434343444', '1');
    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('33129', '76890', 'JOHN', 'WILSON', 'ssss@bb.com', '2323456211', '1');
    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('005678', NULL, 'JOHN', 'SMITH', 'smith@bb.com', '45634562121', '1');
    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('225678', NULL, 'JOHN', 'SMITH', 'aaaa@bb.com', '4563445545', '1');
    Insert into TABX_TO_TABY(COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('335622', NULL, 'JOHN', 'ROGERS', 'rrrttt@bb.com', '34234343', '2');
    Insert into TABX_TO_TABY (COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('234123', NULL, 'TOMMY', 'ROGERS', 'rogers@bb.com', '343411111', '2');
    Insert into TABX_TO_TABY(COD_ID, CID, NAME_FIRST, NAME_LAST, EMAIL, MOBILE, STAT)
    Values ('00888', '78089', 'TOMMY', 'MOODY','mody@bb.com', '345234999', '1');
    COMMIT;


    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('MAL_TOM_123', '00123', 'TOMMY', 'MAL', 'mal@bb.com', 'ROME', '333345698756', '1');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('LUISS_SAM_127', '00127', 'SAMMY', 'LUISS', 'cccc@bb.com', 'LONDON', '97979799333', '1');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('WILSON_JOH_129', '33129', 'JOHN', 'WILSON','ssss@bb.com', NULL, '2323456211', '1');
    COMMIT;


    PROBLEM:
    I'd like to insert (with a STORED PROCEDURE) from TABX_TO_TABY into TABY with these condition:

    CASE1
    If TABX_TO_TABY.COD_ID NOT present into TABY and CID is NULL I must insert into TABY a new record

    CASE2
    If TABX_TO_TABY.COD_ID NOT present into TABY and CID is NOT NULL I must insert into TABY 2 new record:
    first with COD_ID=CID STAT=1
    second with COD_ID=old COD_ID STAT=2

    CASE3
    If TABX_TO_TABY.COD_ID present into TABY and CID is NULL I must check if it has the same values
    If the values are equal than makes no change
    If the values are changed then I have to update these values

    CASE4
    If TABX_TO_TABY.COD_ID present into TABY and CID is NOT NULL I must insert into TABY a new record with TABY.COD_ID=TABX.CID
    and I must update the old COD_ID with STAT=2 and the new COD_ID (=CID) must have the same values of the old COD_ID (NAME_FIRST,NAME_LAST, EMAIL ,CITY, MOBILE)

    FOR EXAMPLE (with my data):

    TABX_TO_TABY.COD_ID = 22129 (CASE1)


    TABX_TO_TABY.COD_ID = 33129 (CASE2)
    To avoid duplication of PK_ID value add '_99' at old COD_ID

    NAME_FIRST,NAME_LAST, EMAIL ,CITY, MOBILE must have same value of the old COD_ID


    - TABX_TO_TABY.COD_ID=00123 (CASE3)


    -TABX_TO_TABY.COD_ID=00127 (CASE4)
    To avoid duplication of PK_ID value add '_99' at old COD_ID
    NAME_FIRST,NAME_LAST, EMAIL ,CITY, MOBILE must have same value of the old COD_ID


    my output looks like this;

    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('MAL_TOM_123', '00123', 'TOMMY', 'MAL', 'mal@bb.com', 'ROME', '333345698756', '1');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('LUISS_SAM_127_99', '00127', 'SAMMY', 'LUISS', 'cccc@bb.com', 'LONDON', '97979799333', '2');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('WILSON_JOH_129', '76890', 'JOHN', 'WILSON', 'ssss@bb.com', NULL, '2323456211', '1');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('WILSON_JOH_129_99', '33129', 'JOHN', 'WILSON', 'ssss@bb.com', NULL, '2323456211', '2');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('LUISS_SAM_127', '00999', 'SAMMY', 'LUISS', 'cccc@bb.com', 'LONDON', '97979799333', '1');
    Insert into TABY (PK_ID, COD_ID, NAME_FIRST, NAME_LAST, EMAIL, CITY, MOBILE, STAT)
    Values ('LUISS_GRA_129', '22129', 'GRACE', 'LUISS', 'mmmm@bb.com', NULL, '3443434343444', '1');
    COMMIT;

    How can I put these cases in a STORED PROCEDURE whereas TABX_TO_TABY has more 10000 records and TABY has more 5000 records?

    Thanks in advance!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >The primary key PK_ID comes from the TABX_TO_TABY table linked in this way:
    >name_last||'_'||substr(name_first,1,3)||'_'||subs t r(cod_id,-3)

    What happens to PK_ID when LENGTH(LAST_NAME)>24?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2002
    Posts
    227
    Quote Originally Posted by anacedent View Post
    >The primary key PK_ID comes from the TABX_TO_TABY table linked in this way:
    >name_last||'_'||substr(name_first,1,3)||'_'||subs t r(cod_id,-3)

    What happens to PK_ID when LENGTH(LAST_NAME)>24?
    I haven't LENGTH(LAST_NAME) > 24

    IF I have I run:
    ALTER TABLE TABY MODIFY(NAME_LAST VARCHAR2(64 BYTE));


    Have someone anyidea How can I write this stored procedure?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OTN Discussion Forums : Oracle Packages ...

    http://asktom.oracle.com has many fine coding examples.

    You could try SEARCH this forum such as "CREATE PROCEDURE"

    Google is your friend but only when you actually use it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2002
    Posts
    227
    I'm trying this stored procedure, BUT I get incorrect values into TABY:

    CREATE OR REPLACE PROCEDURE InsertNewUser IS
    ERR_NUM NUMBER;
    ERR_MSG VARCHAR2(300);
    cod_taby VARCHAR2(64);
    CONTA NUMBER;

    CURSOR a IS
    SELECT A.COD_ID, A.CID, A.NAME_FIRST, A.NAME_LAST, A.EMAIL, A.MOBILE, A.STAT
    FROM TABX_TO_TABY A
    WHERE A.COD_ID NOT IN (SELECT B.COD_ID
    FROM TABY B);

    CURSOR b IS
    SELECT A.COD_ID, A.CID, A.NAME_FIRST, A.NAME_LAST, A.EMAIL, A.MOBILE, A.STAT
    FROM TABX_TO_TABY A
    WHERE A.COD_ID IN (SELECT B.COD_ID
    FROM TABY B);

    BEGIN
    --First Cursor
    FOR cur_ins IN a LOOP


    SELECT COUNT(*)
    INTO CONTA
    FROM TABY;


    IF cur_ins.CID IS NULL THEN


    IF CONTA > 0 THEN


    select NAME_LAST||'_'||SUBSTR(NAME_FIRST,1,3)||'_'||SUBST R(COD_ID,-3)
    into cod_taby
    from taby
    WHERE ROWNUM=1; --(here without rownum=1 I get error)


    --Case without CID
    IF cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST, 1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3) cod_taby THEN
    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST ,1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3),
    cur_ins.COD_ID, cur_ins.NAME_FIRST,cur_ins.NAME_LAST, cur_ins.EMAIL, cur_ins.MOBILE , cur_ins.STAT);
    ELSE
    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST ,1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3)||'_X',
    cur_ins.COD_ID, cur_ins.NAME_FIRST,cur_ins.NAME_LAST, cur_ins.EMAIL, cur_ins.MOBILE , cur_ins.STAT);
    END IF;
    ELSE
    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST ,1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3),
    cur_ins.COD_ID, cur_ins.NAME_FIRST,cur_ins.NAME_LAST, cur_ins.EMAIL, cur_ins.MOBILE , cur_ins.STAT);
    END IF;

    END IF;
    --Case with CID
    IF cur_ins.CID IS NOT NULL THEN


    IF cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST, 1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3) != cod_taby THEN


    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST ,1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3)||'_99',
    cur_ins.CID, cur_ins.NAME_FIRST,cur_ins.NAME_LAST, cur_ins.EMAIL, cur_ins.MOBILE , cur_ins.STAT);


    ELSE


    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_ins.NAME_LAST||'_'||SUBSTR(cur_ins.NAME_FIRST ,1,3)||'_'||SUBSTR(cur_ins.COD_ID,-3)||'_X',
    cur_ins.COD_ID, cur_ins.NAME_FIRST,cur_ins.NAME_LAST, cur_ins.EMAIL, cur_ins.MOBILE , cur_ins.STAT);


    UPDATE TABY
    SET STAT = '2'
    WHERE COD_ID = cur_ins.COD_ID;


    END IF;


    END IF;


    END LOOP;


    COMMIT;


    --Second Cursor
    FOR cur_b IN b
    LOOP
    --Case without CID
    IF cur_b.CID IS NULL THEN


    UPDATE TABY
    SET email = cur_b.email,
    MOBILE = cur_b.MOBILE
    where COD_ID = cur_b.COD_ID;
    END IF;



    --Case with CID
    IF cur_b.CID IS NOT NULL THEN


    IF cur_b.NAME_LAST||'_'||SUBSTR(cur_b.NAME_FIRST,1,3) ||'_'||SUBSTR(cur_b.COD_ID,-3) != cod_taby THEN


    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_b.NAME_LAST||'_'||SUBSTR(cur_b.NAME_FIRST,1,3 )||'_'||SUBSTR(cur_b.COD_ID,-3)||'_99',
    cur_b.CID, cur_b.NAME_FIRST,cur_b.NAME_LAST, cur_b.EMAIL, cur_b.MOBILE , cur_b.STAT);


    ELSE


    UPDATE TABY
    SET STAT = '2'
    WHERE COD_ID = cur_b.COD_ID;


    END IF;


    END IF;


    END LOOP;


    COMMIT;


    END InsertNewUser;


    Have someone any idea How Can I modify this procedure for my cases?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >BUT I get incorrect values into TABY:
    We don't have your tables.
    We don't have your data.
    We don't know what are incorrect values.
    We don't know what are correct values.

    We can't provide any assistance because you have provided us no details.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jul 2002
    Posts
    227
    Quote Originally Posted by anacedent View Post
    >BUT I get incorrect values into TABY:
    We don't have your tables.
    We don't have your data.
    We don't know what are incorrect values.
    We don't know what are correct values.

    We can't provide any assistance because you have provided us no details.
    OK, sorry if I provided you no details

    I create a stored procedure that seem run correctly for cid is null

    CREATE OR REPLACE PROCEDURE InsUpdIDNoCID IS
    ERR_NUM NUMBER;
    ERR_MSG VARCHAR2(300);
    V_COUNT NUMBER;

    CURSOR a IS
    SELECT A.COD_ID, A.CID, A.NAME_FIRST, A.NAME_LAST, A.EMAIL, A.MOBILE, A.STAT
    FROM TABX_TO_TABY A
    WHERE STAT='1';

    BEGIN
    FOR cur_a in a
    LOOP
    IF cur_a.cid IS NULL
    THEN
    SELECT COUNT(*)
    INTO V_COUNT
    FROM TABY b
    WHERE b.COD_ID=cur_a.COD_ID;

    IF V_COUNT = 0 THEN

    INSERT INTO TABY (PK_ID, COD_ID, NAME_FIRST,NAME_LAST, EMAIL ,MOBILE , STAT )
    VALUES (cur_a.NAME_LAST||'_'||SUBSTR(cur_a.NAME_FIRST,1,3 )||'_'||SUBSTR(cur_a.COD_ID,-3),
    cur_a.COD_ID, cur_a.NAME_FIRST,cur_a.NAME_LAST, cur_a.EMAIL, cur_a.MOBILE , cur_a.STAT);

    ELSE

    UPDATE TABY
    SET EMAIL = cur_a.EMAIL,
    MOBILE = cur_a.MOBILE,
    STAT = cur_a.STAT
    WHERE COD_ID = cur_b.COD_ID;

    END IF;
    ELSE
    --here my conditions when cid is not null
    END IF;
    END LOOP;

    COMMIT;

    END InsUpdIDNoCID;
    /

    in ELSE I have a new codndition:
    When the CID IS NOT NULL I have to check the following (new) conditions:
    - If TABX_TO_TABY.cid not in (taby.cod_id) then raise alert (when CID is not null TABX_TO_TABY.cid must exists into TABY else raise error)

    - If TABX_TO_TABY.cod_id in (taby.cod_id) then update taby (email, mobile, stat....)

    - If TABX_TO_TABY.cod_id not in (taby.cod_id) then insert new cod_id into taby (with stat=1) with data (email, mobile,city...) ugual to record with
    cod_id=cid and then I put the stat = 2

    FOR EXAMPLE:
    TABX_TO_TABY:
    COD_ID..........CID...........NAME_FIRST......NAME _LAST.......EMAIL...............MOBILE.......STAT
    00127..........00999.............SAMMY..........LU ISS..............aa@bb.com.........0033221........ .1
    00155..........77999..........SAMMY............LUI SS............. aa@bb.com........ 0033221......... 1 -- here cid=77999 not present into taby then raise error (exception?)

    TABY:
    PK_ID................COD_ID.........NAME_FIRST.... .....NAME_LAST.........EMAIL........CITY.......MOB ILE.....STAT
    LUISS_SAM_999...009999........SAMMY..............L UISS.............ddd@bb.com....ROME......00777771. ...1

    TABY becomes:
    PK_ID................COD_ID.........NAME_FIRST.... .....NAME_LAST.........EMAIL........CITY.......MOB ILE.....STAT
    LUISS_SAM_999...009999........SAMMY..............L UISS.............ddd@bb.com....ROME......00777771. ...2
    LUISS_SAM_127.....00127........SAMMY............LU ISS...............ddd@bb.com....ROME.......0077777 1...1


    How can I put in ELSE these conditions?

    Thanks in advace!

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    CREATE OR REPLACE PROCEDURE Insupdidnocid
    IS
      err_num  NUMBER;
      err_msg  VARCHAR2(300);
      v_count  NUMBER;
      CURSOR a IS
        SELECT a.cod_id,
               a.cid,
               a.name_first,
               a.name_last,
               a.email,
               a.mobile,
               a.stat
        FROM   tabx_to_taby a
        WHERE  stat = '1';
    BEGIN
      FOR cur_a IN a LOOP
        IF cur_a.cid IS NULL THEN
          SELECT Count(* )
          INTO   v_count
          FROM   taby b
          WHERE  b.cod_id = cur_a.cod_id;
          
          IF v_count = 0 THEN
            INSERT INTO taby
                       (pk_id,
                        cod_id,
                        name_first,
                        name_last,
                        email,
                        mobile,
                        stat)
            VALUES     (cur_a.name_last
                        ||'_'
                        ||Substr(cur_a.name_first,1,3)
                        ||'_'
                        ||Substr(cur_a.cod_id,-3),
                        cur_a.cod_id,
                        cur_a.name_first,
                        cur_a.name_last,
                        cur_a.email,
                        cur_a.mobile,
                        cur_a.stat);
          ELSE
            UPDATE taby
            SET    email = cur_a.email,
                   mobile = cur_a.mobile,
                   stat = cur_a.stat
            WHERE  cod_id = cur_b.cod_id;
          END IF;
        ELSE
          cod_id := cod_id;
        END IF;
      END LOOP;
      
      COMMIT;
    END insupdidnocid;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Jul 2002
    Posts
    227
    Quote Originally Posted by anacedent View Post
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
    PL/SQL Release 10.2.0.3.0 - Production
    CORE 10.2.0.3.0 Production
    TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
    NLSRTL Version 10.2.0.3.0 - Production


    ELSE
    cod_id := cod_id;
    What does it mean?

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What does it mean?
    The brain dead SQL formatter refused to format the code with a comment in that branch.
    The reality is that it IS invalid SQL to have a branch with nothing to execute.
    I added a do nothing line to obtain the formatted procedure.
    I forgot to replace my line with your comment when I posted back here.

    Code:
          IF v_count = 0 THEN
            INSERT INTO taby
                       (pk_id,
                        cod_id,
                        name_first,
                        name_last,
                        email,
                        mobile,
                        stat)
            VALUES     (cur_a.name_last
                        ||'_'
                        ||Substr(cur_a.name_first,1,3)
                        ||'_'
                        ||Substr(cur_a.cod_id,-3),
                        cur_a.cod_id,
                        cur_a.name_first,
                        cur_a.name_last,
                        cur_a.email,
                        cur_a.mobile,
                        cur_a.stat);
          ELSE
            UPDATE taby
            SET    email = cur_a.email,
                   mobile = cur_a.mobile,
                   stat = cur_a.stat
            WHERE  cod_id = cur_b.cod_id;
          END IF;
    The whole IF ... THEN ... ELSE can be replaced with a single MERGE statement
    http://download.oracle.com/docs/cd/B...6.htm#i2081218
    Last edited by anacedent; 12-04-09 at 22:30.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •