1 Reply Latest reply on May 19, 2006 10:20 AM by Dan Bracuk

    access database with data from a sruct

      hi @ all..... i´ve got a question about how to access a db with data from a sruct.

      my struct is called application.names. contains (name1,name2,name3,.....etc.)

      now i want to find these names in a database. is there a possibility to do it with some similar function like

      this would look like

      <cfquery name ="qnames" datasource="#application.dsn#" maxrows="20">

      select name, xyz
      from tbl
      where #valuelist(application.names,",")#


      but this doesn´t work . also the function #StructKeyList(application.names,",")# gives no record.

      i would be thankfull for any suggestions.