6 Replies Latest reply on Mar 21, 2011 8:56 AM by plarts

    CF8 and ACCESS 2007 and cfoutput

    plarts Level 1

      I installed the required ODBC driver for Access 2007 on CF8. Fine.

      I declare a new DATASOURCE if CF (socket ODBC) fine

       

      I write a CF file with a simple query (select) , the cfouput

      Almost fine,

      except that : the displayed data is encountered by the #  (like the called variable)

       

      Here the code  :

      <cfoutput>

      <cfquery name="liste_ad" datasource="test_r4">
           select * from Descriptif_vehicules
      </cfquery>

      <cfloop query="liste_ad">
           #source_disponibilite#<br>
      </cfloop>

      </cfoutput>

       

      here is the Display : (a single record in the base)

       

      #http://www.avto.net/_AVTO/ad.asp?ID=4418041&show=1#

       

      It has to be :

      http://www.avto.net/_AVTO/ad.asp?ID=4418041&show=1

      which is the data in the Access (.accdb file)  DB

       

      How to get reed of the 2 x #    ???

       

      Thanks for any help ?

      Pierre.