Hi all,
I just downloaded the trial verson of MX and am having
an unusual problem. I've got an access table with a
number of fields/datatypes. When I query the table
and output the results, all the fields will display
with the exception of the memo fields.
Here's the query:
<cfquery name="GetJobs" datasource="#thesource#">
SELECT *
FROM tblCareers
WHERE Display = yes
ORDER BY LastModified
</cfquery>
Here's the part that won't display:
<tr>
<td valign="TOP"><b>Requirements:</b></td>
<td><cfif getjobs.requirements is "">It's
Blank<cfelse>#ParagraphFormat(Requirements)#</cfif></td>
</tr>
<tr>
<td valign="TOP"><b>Education / Experience:</b></td>
<td>#ParagraphFormat(Experience)#</td>
</tr>
I even wrapped the "requirements" in that if statement
to see what would display and sure enough, "It's
Blank" is what's shown. And yes, I'm sure that there
is data in those fields.
Any ideas?
TIA
Katie
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
