hi
i have been looking at this query for ages and cannot understand the error i am
getting:
i have 2 queries and am running a query on query to joi n them together but the
error message i am getting is:
A1001 must be interpretable as a valid number in the current locale.
and i have no idea what that means
the query i am running is:
<cfquery name="filteredQuery1" dbtype="query">
select
a.ASTHMA,a.AZDX_AGE_Y,a.BTS,a.BTSDX_AGE_M,a.BWT,a.B_MULTI,a.DOB,a.ECZEMA,a.F_MEDPROB,a.GEST_D,a.GEST_W,a.HF,a.M_EGROUP,a.M_FTE,a.M_MEDPROB,a.M_OCC,a.M_PSM,a.PCGH3W,a.PNEUMDX_AGE_M,a.PNEUMONIA,a.QUESTIONNAIRENAME,a.SEX,a.STUDYNUMBERS,a.SUBJECTID,a.WHEEZE,a.WHEEZE_EVER,a.WZDX_AGE_M,b.ASTHMA_Y2,b.ASTHMA_Y6,b.BWZ_CGF,b.BWZ_LOCAL,b.CPAPEDD,b.EPIGROUP,b.LENGTH_EDD,b.O2EDD,b.O2_Y1,b.OFC_EDD,b.OXY40W,b.TB,b.WHCGHDX_AGE,b.WHCGH_HP,b.WHCOUGH,b.WT_EDD
from a, b
where a.subjectID = b.subjectID;
</cfquery>
it all seems fine to me but i have no idea where the error is coming from
there is a cell with data A1001 but it isnt in the subjectID primary key field
so i dont see why it would produce such a crazy error message
i would appreciate it if anyone had any ideas
thanks
richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304941
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
