CodingForums.com - View Single Post

CM670 · 10-19-2012, 12:12 PM

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!

10-19-2012, 12:12 PM	PM User \| #1
CM670 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!