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

  1. #1

    Default database access

    hai~ why when i run my coding, it shows error executing database query. so, wut's the prob actually?? n actually i'm still new wif coldfusion n in a learning process.so can someone help me?tq
    pearl_honey Guest

  2. Similar Questions and Discussions

    1. Access Database
      Hello. We have a database that we does like to use in a movie. How can we do that? Need any special Xtra? Thanks for help Paul and Mike
    2. access to database
      hi to everybody. i'm a newbie in the world of mysql and i've got a problem with the access to a database. i created a user 'default', from host %,...
    3. .NET Database access
      post the connection script with the full path to the database. also since your site is probably not on the root of the drive make sure you are...
    4. Web access to database
      Hi. I've built a quite complicated database for tracking clients, projects, logging work, etcetera for my company, over the last few years. Now...
    5. Write Access to Access DataBase
      I'm trying to update a Access Database from information gained from a ASPX page. The database will not update. I'm sure it is in some security...
  3. #2

    Default Re: database access

    > hai~ why when i run my coding, it shows error executing database query.
    so, wut's the prob actually?? n actually i'm still new wif coldfusion n in a
    learning process.so can someone help me?tq

    You need to give us the error that is displayed and the cf code around the
    place where the error occurs.

    --
    <mack />


    Neculai Macarie Guest

  4. #3

    Default Re: database access

    you need to post some code


    jorgepino Guest

  5. #4

    Default Re: database access

    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    -------------
    This is the coding :

    <body>
    <cfquery name="borang" datasource="db1.mdb">
    SELECT Pegawai.Firstname, Pegawai.Lastname,Pegawai.NoStaff, Pegawai.Gred,
    Pegawai.Position, Pegawai.Address, Pegawai.phone1, Pegawai.phone2
    FROM Pegawai
    </cfquery>
    <cfoutput query="pegawai">
    <p>#form.FirstName#</p>
    <p>#form.LastName# </p>
    <p>#form.NoStaff#</p>
    <p>#form.Gred#</p>
    <p>#form.Position#</p>
    <p>#form.Address#</p>
    <p>#form.phone1#</p>
    <p>#form.phone2#</p>
    </cfoutput>


    </body>


    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    --

    is it the prob coming from the coding or from my database?

    +thanks 4 helping+

    pearl_honey Guest

  6. #5

    Default Re: database access

    The name of the query you want to output is borang
    so change the following
    <cfoutput query="pegawai">

    to

    <cfoutput query="borang">

    Ken

    The ScareCrow Guest

  7. #6

    Default Re: database access

    i knoe nothing bout cfml..but i want to try to develope 1 system wif cfml.so,
    i'm still in a learning process...i want to know how to create a form.which is
    when i fill the form all the data will go into the database n i can view the
    data back. tq..

    pearl_honey Guest

  8. #7

    Default Database Access

    I've installed MySQL 5.022 with ColdFusion MX7 using the driver
    mysql-connector-java-3.1.13 (from MySQL.com). I'm getting a message in
    DreamWeaver that certain MySQL datatypes aren't recognized (specifically
    interger and mediuminteger). I'm using the driver recommended by Macromedia
    technicians to get around a problem with the 3.1.11 MySQL driver. I noticed
    that a MySQL 5.0 driver is in development, but I don't want to use it until
    it's stable.

    Does anyone have any advice on how I can fix this?

    redriver0219 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