access database with data from a sruct
hi @ all..... i´ve got question how access db data sruct.
my struct called application.names. contains (name1,name2,name3,.....etc.)
now want find these names in database. there possibility similar function
#valuelist(application.names,",")#
this
<cfquery name ="qnames" datasource="#application.dsn#" maxrows="20">
select name, xyz
tbl
#valuelist(application.names,",")#
</cfquery>
but doesn´t work . function #structkeylist(application.names,",")# gives no record.
i thankfull suggestions.
my struct called application.names. contains (name1,name2,name3,.....etc.)
now want find these names in database. there possibility similar function
#valuelist(application.names,",")#
this
<cfquery name ="qnames" datasource="#application.dsn#" maxrows="20">
select name, xyz
tbl
#valuelist(application.names,",")#
</cfquery>
but doesn´t work . function #structkeylist(application.names,",")# gives no record.
i thankfull suggestions.
select somefields
from sometables
where anumericfield in (#application.numbers#)
or acharacterfield in (#listqualify(application.names, "'")#)
from sometables
where anumericfield in (#application.numbers#)
or acharacterfield in (#listqualify(application.names, "'")#)
More discussions in Advanced Techniques
adobe
Comments
Post a Comment