Ask a Question related to Coldfusion Database Access, Design and Development.
-
travelerkgd #1
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
-
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,... -
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... -
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... -
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... -
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... -
supportcenter #2
Re: Connecting to phpadmin/mySQL Database withColdFusion File
Maybe without the Dollar-signs?
supportcenter Guest
-
travelerkgd #3
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



Reply With Quote

