I have a query like:
<cfquery name="getProduct" datasource="#APPLICATION.dsn>
SELECT Products.*
WHERE Product_ID = 2
</cfquery>
One of the fields in Products is "P_IsApproved_YN".
The query returns 1 record (which it should).
ALL of the data is correct that it returns...EXCEPT...
P_IsApproved_YN!!!
I look in the database, and this field is a 0 (in a bit field), but when
I output it straight, it claims it's 1 (and when I output with
YesNoFormat, it claims "yes").
<cfoutput query="getProduct">is approved is #P_IsApproved_YN#</cfoutput>
or
<cfoutput>#YesNoFormat(getProduct.P_IsApproved_YN)#</cfoutput>
I look at the database, it's one thing (the correct thing)...I output it
to the screen it's another (the wrong thing!!).
I know I'm querying the same database I am looking at.
I have forced any caching to DIE.
What else can I do? What am I missing?
-- Loretta Pioch
p.s...this is true for all the product IDs in the database...not just
the one.
------------------------------------------------------------------------------
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.
