Ok, maybe it's just been a long day I don't know. Anyway, here is a very
basic query to an Access database for development. Here is my question, if
I include the Query="RES_INSTALL_PROFILES" in my output, I get NOTHING,
Nada, Zero. But as soon as I pull it out and run the output I get the
number of records and it's right. What am I missing, I have almost always
put that query in there, should I not be doing that, or am I missing
something else. Please advise. Thanks.
<CFQUERY DATASOURCE="#ATTRIBUTES.DSN#" NAME="RES_INSTALL_PROFILES">
SELECT
TITLE,
PRODUCT,
DESIGN_OBJECTIVE,
FLOORING_SOLUTION,
IMAGE,
IMAGE_CAPTION_1,
IMAGE_CAPTION_2,
PROFILE_NUM
FROM
RESILIENT_INSTALLATION_PROFILES
WHERE PROFILE_NUM = '#PROFILE#'
</CFQUERY>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" align="left">
<CFOUTPUT>
#RES_INSTALL_PROFILES.RECORDCOUNT#
</CFOUTPUT>
</td>
</tr>
</table>
Bill Killillay
ICQ @ 8425781
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
"An investment in Knowledge always pays the best interest."
-Benjamin Franklin-
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Get Paid to Surf the Web. It's free, easy and fun.
Sign up for AllAdvantage.com at
http://alladvantage.com/go.asp?refid=FIB-034
Most of us are on it every day all day anyway, why not give
yourself a pay raise for 25 hours a month.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
