thanks again brad its working perfectly now :) i have learned something new as
well :)
> 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:304950
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
