Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Dreamweaver unable to read Access memo field

I have a cfm page which contains several which contains several fields in a Dynamic Table.  The table is connected to a Microsoft Access database through Cold Fusion.  Everything works fine except the Text area Fields which are connected to a "memo field" in Access.  A memo field is necessary because of the large volume of letters in the Access field.  I am getting the following error when I try to run the page with the text area field:

Error Occurred While Processing Request  
Invalid CFML construct found on line 64 at column 37.  
ColdFusion was looking at the following text:
For

The CFML compiler was processing:

An expression that began on line 64, column 17.
Your expression might be missing an ending "#" (it might look like #expr ).
The body of a cfoutput tag beginning on line 56, column 12.

I dont know what I need to use to display the contents of the Access memo field in the dreamWeaver page.  Thank You
 
0
misnstt
Asked:
misnstt
  • 3
  • 2
1 Solution
 
Ryan ChongCommented:
try check and make sure when you display your values starting with #, it should always close with # as well ?
0
 
misnsttAuthor Commented:
Yes I am using #ClientDetails.Looking For# in the value for the dynamic text field.  ClientDetails is the name of the recordset and Looking for is tha name of the field from Access which is a memo field.  
0
 
Ryan ChongCommented:
Can you post your scripts here?
0
 
misnsttAuthor Commented:
I am attaching the script for the pge.  All the fields fork fine except for the last one #ClientDetails.Looking For# in the scrips which is attached to a MEMO field in Access in lieu of a TEXT field in Access.  I am using a Dynamic Text Field in Dreamweaver.  I have to use a MEMO field in Access because of the large amount of words for the field.
Thank you


<cfparam name="URL.id" default="1">
<cfquery name="ClientDetails" datasource="cprogram">
SELECT * FROM Contacts Where id = #URL.id#
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
body {
      background-color: #FFFFFF;
}
.style6 {
      font-family: Geneva, Arial, Helvetica, sans-serif;
      color: #339999;
}
.style7 {font-family: Geneva, Arial, Helvetica, sans-serif}
.style8 {color: #CC0033; font-family: Geneva, Arial, Helvetica, sans-serif; }
.style9 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: x-large; }
-->
</style>
</head>

<body>

<div align="left">
  <table width="824" height="100" border="0">
    <tr>
      <td align="left">&nbsp;</td>
    </tr>
  </table>
  <table width="820" border="0">
    <tr>
      <td width="134" align="left" valign="top" bgcolor="#FF0000"><p>&nbsp;</p>
          <p>&nbsp;          </p>
          <p>
            <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="134" height="30">
              <param name="movie" value="button4.swf">
              <param name="quality" value="high">
              <embed src="button4.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="134" height="30" ></embed>
            </object>
          </p>
          <p>&nbsp;</p>
          <p>&nbsp;          </p>
          <p>&nbsp;</p>
          <p>&nbsp;</p>
          <p>&nbsp;</p>
      <p>        <span class="style7">
      </span></p></td>
      <td width="676" valign="top"><p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>        <table border="0" align="center">
          <tr>
            <td><div align="center"></div></td>
            <td align="left" valign="bottom"><p><img src="<cfoutput>#ClientDetails.Photo#</cfoutput>"></p>
                <div align="center"><cfoutput>#ClientDetails.id#</cfoutput><cfoutput><span class="style1">#ClientDetails.Photo#</span></cfoutput> </div>
                <form name="form1" method="post" action="">
                  <div align="center"> </div>
              </form></td>
          </tr>
          <cfoutput query="ClientDetails">
            <tr>
              <td><span class="style7"></span></td>
              <td align="left"><span class="style8">#ClientDetails.ClientNumber#</span></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td align="left">&nbsp;</td>
            </tr>
            <tr>
              <td><span class="style8">Name</span></td>
              <td align="left"><span class="style8">#ClientDetails.FirstName#<a href="Private%20Images%20Screen.cfm?id=#id#">#ClientDetails.LastName#</a></span></td>
            </tr>
            <tr>
              <td><span class="style8">Location</span></td>
              <td align="left"><span class="style8">#ClientDetails.City# #ClientDetails.StateOrProvince#</span></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td align="left">&nbsp;</td>
            </tr>
            <tr>
              <td><span class="style8">Height</span></td>
              <td align="left"><span class="style8">#ClientDetails.Height#</span></td>
            </tr>
            <tr>
              <td><span class="style8">Weight</span></td>
              <td align="left"><span class="style8">#ClientDetails.Weight#</span></td>
            </tr>
            <tr>
              <td><span class="style8">Measurements</span></td>
              <td align="left"><span class="style8">#ClientDetails.Measurements#</span></td>
            </tr>
            <tr>
              <td><span class="style8">Religion</span></td>
              <td align="left"><span class="style8">#ClientDetails.Religion#</span></td>
            </tr>
            <tr>
              <td><span class="style8">Status</span></td>
              <td align="left"><span class="style8">#ClientDetails.Status#</span></td>
            </tr>
            <tr>
              <td><span class="style8">Age</span></td>
              <td align="left"><span class="style8">#ClientDetails.Age#</span></td>
            </tr>
            <tr>
              <td><span class="style8">Ocupation - Profession </span></td>
              <td><span class="style7"></span></td>
            </tr>
            <tr>
              <td><span class="style7"></span></td>
              <td><span class="style7">#ClientDetails.Looking For#
0
 
Ryan ChongCommented:
>><td><span class="style7">#ClientDetails.Looking For#
hmmm... just a quick guess, is it the table field's name is as "Looking For" ? basically i think that's where the problem comes from (and is it), so try these suggestions:

1. try change:

#ClientDetails.Looking For#

to:

#ClientDetails.[Looking For]#

2. if above not working, try do some "tricks" at your sql statement, try like:

<cfquery name="ClientDetails" datasource="cprogram">
SELECT *, [Looking For] As LookingFor FROM Contacts Where id = #URL.id#
</cfquery>
....

then change:

#ClientDetails.Looking For#

to:

#ClientDetails.LookingFor#

3. if both not working, directly rename the field "Looking For" to a new name without space between, like "LookingFor"

and then try sql statement like:

<cfquery name="ClientDetails" datasource="cprogram">
SELECT * FROM Contacts Where id = #URL.id#
</cfquery>

and finally change:

#ClientDetails.Looking For#

to:

#ClientDetails.LookingFor#


Hope this helps and clear, let us know if you still got difficuties resolve your problem, regards
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now