title: Extracting text from cache database with Cache Server Pages (CSP)
body: <p>I am currently experiencing a problem extracting text from a Cache database. My CSP page is written in the following manner:</p>
  
  <pre><code>[...]
  &lt;csp:search name="MySearch" classname="dbo.Story" where="storyId" predicates="&gt;" select="storyId,storyName,author,notes,text" options="predicates,popup,leaveopen,sortbox" caption="This is the Story Search Box"&gt;  
  &lt;center&gt;  
  &lt;INPUT TYPE="button" NAME="Search" VALUE="Search" ONCLICK="MySearch();"&gt;  
  &lt;/center&gt;  
  [...]
  </code></pre>
  
  <p>NOTE: The table that I am querying is the <code>dbo.Story</code> or just Story table. The columns in that table are the <code>storyId</code>, <code>storyName</code>, <code>author</code>, <code>notes</code>, <code>text</code>, etc...</p>
  
  <p>The <code>storyId</code>, <code>storyName</code>, <code>author</code>, and <code>notes</code> fields are all displaying correctly, however the values returned in the <code>text</code> column all resemble something like this:</p>
  
  <pre><code>^dbo.StoryS)dt.common.streams.GlobalCharacterStream ^dbo.StoryS
  </code></pre>
  
  <p>NOTE: A direct reference to the database (a “global reference”) is essentially a multidimensional array reference preceded by the carat character <code>^</code>. That character indicates this is a reference to data stored in the database rather than to temporary process private data. Each such database array is called a “global”. </p>
  
  <p>I want to be able to see what's in the stream but instead I'm getting something that looks like a reference. Has anyone dealt with this kind of thing before?</p>