CodingForums.com - View Single Post

Chandler_90 · 04-01-2006, 03:54 PM

This is almost exactly what I need to do..

I'm trying to write a menu for a restaurant's website which has to be updatable from a database.
I have only been taught asp..
I have made the connection to the database and I'm simply going to store the entire menu in one field.. that can be edited using one text box with all the information in.

However...
I'm using the following coding -

<li>x</li> - Where x is the menu item.

Therefore if I want 5 menu items I am going to repeat the above 5 times in the database field.
This then presents a probelm when retrieving the data and displaying in a text box for editing.

How would I format the database entry so that it reads -

<li>x</li>
 
<li>x</li>
 
<li>x</li>
 

And not

<li>x</li> <li>x</li> <li>x</li> 

?

I've tried using vbcrlf but I'm unsure of how to apply it correctly.
Thanks for any help..

04-01-2006, 03:54 PM	PM User \| #5
Chandler_90 New to the CF scene Join Date: Apr 2006 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	This is almost exactly what I need to do.. I'm trying to write a menu for a restaurant's website which has to be updatable from a database. I have only been taught asp.. I have made the connection to the database and I'm simply going to store the entire menu in one field.. that can be edited using one text box with all the information in. However... I'm using the following coding - <li>x</li><br> - Where x is the menu item. Therefore if I want 5 menu items I am going to repeat the above 5 times in the database field. This then presents a probelm when retrieving the data and displaying in a text box for editing. How would I format the database entry so that it reads - <li>x</li> <br> <li>x</li> <br> <li>x</li> <br> And not <li>x</li><br><li>x</li><br><li>x</li><br> ? I've tried using vbcrlf but I'm unsure of how to apply it correctly. Thanks for any help..