CFMX refusing query 'connectstring' attribute

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Re: CFMX refusing query 'connectstring' attribute

    What should then be used? I connect dynamicly to an excell sheet with the
    following: <CFQUERY name='GetEmployeeId' dbtype='DYNAMIC'
    ConnectString='Driver={Microsoft Excel Driver (*.xls)}; DBQ=#GetSetUp.Path#;
    FIL=MSExcel; MaxBufferSize=2048; PageTimeout=5' > What should I use instead?
    It has to be dynamicly Morten Kruse Capgemini Denmark

    kruse Guest

  2. Similar Questions and Discussions

    1. #39505 [NEW]: xpath query failed if root element has xmlns attribute
      From: sghnqk at gmail dot com Operating system: linux PHP version: 5.2.0 PHP Bug Type: DOM XML related Bug description: ...
    2. How to query a MDE Database for reading with CFMX?
      Hi, I need to query a protected MDE Access Database, but I cannot select the DB in the CFMX Admin. What can I do? and how? Is there an other way...
    3. Update query fails in CFMX - Is it a CF BUG???
      Hi, I have a update query in coldfusion page. Even though it works in cf5 it fails in CFMX. My query is some thing like (I have put a CF output...
    4. Query works in fine CF5 but not CFMX
      I have a simple query against an Oracle database that works in CF 5 but not in CFMX. In CF 5 I get one record which is what I want, but in CFMX I...
    5. CFMAIL AND QUERY ATTRIBUTE
      Does the cfmail tag recognize queries obtained from QOQs? That is, does it recognize it as a query and therefore sends the email to all receipients...
  3. #2

    Default Re: CFMX refusing query 'connectstring' attribute

    I found this on the macromedia livedocs:
    [url]http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt218.htm[/url]
    Quote jrunrandy said on Oct 31, 2003 at 10:40 AM : Unfortunately, there is
    no way, in CFMX or CFMX 6.1 to do this. That is just to bad :-(

    kruse Guest

  4. #3

    Default Re: CFMX refusing query 'connectstring' attribute

    i haven't done this myself but the examples never looked that har, so maybe give [url]http://jakarta.apache.org/poi/hssf/index.html[/url] a look.

    PaulH Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139