>
> <cfquery name="getjoin" datasource="bellccbatch" >
> Select BATCH_DATE from #variables.tablename#
> </cfquery>
>
> I get the batch date.
>
> But when I try this
>
> <cfquery name="getjoin" datasource="bellccbatch" >
> Select BATCH_DATE from #variables.tablename#
> where #dateformat(getjoin.BATCH_DATE, "yyyymmdd")#|| '_fr.htm'
> IN <cfqueryparam list="yes"
> cfsqltype="cf_sql_char" value="#ValueList(getfiles.name)#">
> </cfquery>
>
> I get this error.
>
> Element BATCH_DATE is undefined in GETJOIN.
Apparently the value of variables.tablename id not getjoin.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
