StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPassing text from mysql to javascript on JSP page
primarykey
Id
15095213
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-26T17:15:08.077
FavoriteCount
0
LastActivityDate
2013-02-27T16:14:01.393
LastEditDate
2013-02-26T17:22:37.330
LastEditorUserId
906443
OwnerUserId
906443
ParentId
0
PostTypeId
1
Score
0
ViewCount
120
LastEditorDisplayName
text
Body
<p>I have a block of text I store in a mysql table as longtext and then I retrieve using struts bean:define for jsp. I want to retrieve this block of text for use in a jquery UI dialog which means the text must be parsed with the "\n" characters. Currently the text comes out like</p> <pre><code>emailMSG[1] = "%fn %ln, Our records indicate that certification in %gn, %cn, %sn expire(d) on %dt. Please take the refresher course. Please visit our portal to log into your training. Please ignore any messages from CITI regarding course expiration. DO NOT log in directly to the CITI site."; </code></pre> <p>I need the data to be in this format:</p> <pre><code>emailMSG[<%=id%>] = "%fn %ln,\n"+ "\n" + "Our records indicate that certification in %gn, %cn, %sn expire(d) on %dt.\n"+ "\n" + "Please take the refresher course at the training site.\n"+ "\n" + "Please visit our portal to log into the site.\n"+ "\n"+ "Please ignore any messages from CITI regarding course expiration. DO NOT log in directly to the CITI site."; </code></pre> <p>How can I get the "\n"+ characters in the data coming out of the mysql table?</p> <p>Here is the bit of my code that references this part (I removed the non relevant pieces):</p> <pre><code><logic:iterate id="cel" name="CourseEmailList" scope="request"> <bean:define id="msg" property="message" name="cel" scope="page" type="java.lang.String"/> <bean:define id="id" property="id" name="cel" scope="page" type="java.lang.String"/> <tr> <logic:notEmpty name="cel" property="message" scope="page"> <td><a href="#" onclick="OpenDialog(<bean:write name='cel' property='id' scope="page"/>);return false;">View/Modify</a> <script type="text/javascript"> courseIDs[<%=id%>] = "<%= id%>"; emailMSG[<%=id%>] = "<%= msg%>"; </script> </td> </logic:notEmpty> </tr> </logic:iterate> </code></pre>
Tags
<javascript><html><mysql>
Title
Passing text from mysql to javascript on JSP page
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USEvilsithgirl
UserOwnerUserId
1. USEvilsithgirl
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.