query of queries
hi
i cant possibly figure out what's going on query of queries nad like, seems may have wrong syntax or cause following error:
the system has attempted use undefined value, indicates programming error, either in code or system code.
null pointers name undefined values.
i setted queries follows :
<cfquery name="master" datasource="#dns#" cachedwithin="#createtimespan( 0,0,10,0 )#">
select * users
</cfquery>
<cfquery name="details" dbtype="query">
select * master
where have <cfqueryparam value="%#trim(url.have)#%" cfsqltype="cf_sql_varchar">
order tradername asc
</cfquery>
the #url.have# exists why wont show results when cfoutput them ?
is there wrong in queries far ?
i've tried without cfqueryparam still same problem , nobody seems know why
does see dont see ?
i cant possibly figure out what's going on query of queries nad like, seems may have wrong syntax or cause following error:
the system has attempted use undefined value, indicates programming error, either in code or system code.
null pointers name undefined values.
i setted queries follows :
<cfquery name="master" datasource="#dns#" cachedwithin="#createtimespan( 0,0,10,0 )#">
select * users
</cfquery>
<cfquery name="details" dbtype="query">
select * master
where have <cfqueryparam value="%#trim(url.have)#%" cfsqltype="cf_sql_varchar">
order tradername asc
</cfquery>
the #url.have# exists why wont show results when cfoutput them ?
is there wrong in queries far ?
i've tried without cfqueryparam still same problem , nobody seems know why
does see dont see ?
don't use cfqueryparam q of q. adds no value , complicates life. in fact, don't know if works.
More discussions in Getting Started
adobe
Comments
Post a Comment