Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: Insert

  1. #1
    New to the CF scene
    Join Date
    Oct 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert

    Hi,

    I have a table which holds the status of peoples orders. It holds information on order_id
    order_status
    order_desc
    letter.

    Different letters are printed automatically according to the status of the order.

    However when the status is 'Dispatch' i need two letters to be printed.

    I have tried

    Code:
    Insert into orderstatus (order_id,order_status, 
    order_desc, letter) values('025', 'Dispatched', 'Black tailored coat ','DPTdoc DPT2doc');
    This only prints the first letter, (the DPTdoc) but not the second (DPT2doc).

    Does anyone have any ideas on how to fix this?

    Thanks!

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    Yes, normalize your data. Multiple values do not belong in a single column.


  •  

    Tags for this Thread

    Posting Permissions

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