Connecting to phpadmin/mySQL Database with ColdFusionFile

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

  1. #1

    Default Connecting to phpadmin/mySQL Database with ColdFusionFile

    Hello:

    The web hosting service I am with provides its own database interface run by
    myPhP Admin/MySQL and I cannot seem to connect teh ColdFusion File to the
    database.

    Here's what I was told to use:
    <cfif IsDefined("FORM.EmailAddress")>
    <cfquery datasource="$domain_net" password="$db_password"
    username="$db_username" name="table_name">
    SELECT * FROM tblatsign
    WHERE EmailAddress = '#FORM.EmailAddress#'
    </cfquery>

    And here is the response I get in return, when attempting to submit the form:
    Attribute validation error for tag CFINSERT.
    The tag does not allow the attribute(s) NAME. The valid attribute(s) are
    CONNECTSTRING,DATASOURCE,DBNAME,DBPOOL,DBSERVER,DB TYPE,FORMFIELDS,PASSWORD,PROVI
    DER,PROVIDERDSN,TABLENAME,TABLEOWNER,TABLEQUALIFIE R,USERNAME.

    The error occurred in /home/scubakgd/airtightproductions-www/atroster2.cfm:
    line 25

    23 : <cfelse>
    24 : <!--- Add user to mailing list --->
    25 : <cfinsert datasource="$airtightproductions_org" password="$db_GQ"
    username="$db_scuba" name="$table_at">
    26 :
    27 : <!--- Show message and stop here --->


    Thanks.. I I changed my login information yto prevent hackers from accessing
    my account.



    travelerkgd Guest

  2. Similar Questions and Discussions

    1. Connecting to MySql
      I have installed MySql on a Windows 98 workstation. I start the service with the command: mysqld I can connect to the database and see tables,...
    2. Connecting to MySQL 5.0, How?
      Hi, I run everything on my local machine that is WIN XP SP2 with IIS, Coldfusion MX7.0 I just installed MySQL5.0, the service is running and can...
    3. Connecting with MySQL
      How I do to connect the ColdFusion with MySQL? I read http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 page, but it doesn't works...
    4. difficulty connecting to mysql database usingdreamweaver
      Hi all i'm having trouble connecting to my database in dreamweaver. i'm using an osx mac (panther) with the onboard version of php, version...
    5. connecting mysql
      im having trouble viewing any results from my db, ive recently switched to a mac and have it all running locally, i have no trouble accessing the...
  3. #2

    Default Re: Connecting to phpadmin/mySQL Database withColdFusion File

    Maybe without the Dollar-signs?
    supportcenter Guest

  4. #3

    Default Re: Connecting to phpadmin/mySQL Database withColdFusion File

    I was told to use the dollar signs as they have MySQL/phpadmin... the Standard Cold Fusion code here won't work...
    travelerkgd 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