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.

select somefields
from sometables
where anumericfield in (#application.numbers#)
or acharacterfield in (#listqualify(application.names, "'")#)


More discussions in Advanced Techniques


adobe

Comments

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

How to format a Get Request

avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62