How do you use MYSQL in ColdFusion? [closed]

by

I’m surprised if you couldn’t find anything on how to connect to a MySQL datasource. Here’s Adobe’s list of settings to use in CF Administrator. The important part here is the name you give it.

Because then in your queries or stored procs, you use that name to reference the datasource:

<cfquery name="yourQuery" datasource="name of datasource">

<cfstoredproc procedure="yourProcedure" datasource="name of datasource">

Here’s more links Google showed up:

More Related Contents:

  1. ColdFusion Parameterizing a Query
  2. MySQL: @variable vs. variable. What’s the difference?
  3. How to enable MySQL Query Log?
  4. Join between tables in two different databases?
  5. MySQL: How to reset or change the MySQL root password?
  6. How to select a column name with a space in MySQL [duplicate]
  7. Are you allowed to use numbers as table names in MySQL?
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. How do you select every n-th row from mysql
  10. Howto: Clean a mysql InnoDB storage engine?
  11. Add Foreign Key to existing table
  12. Auto Generate Database Diagram MySQL [closed]
  13. How to access remote server with local phpMyAdmin client?
  14. What’s the difference between using INDEX vs KEY in MySQL?
  15. MySQL/Writing file error (Errcode 28)
  16. mysql select top n max values
  17. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  18. MySQL Trigger: Delete From Table AFTER DELETE
  19. Return a default value if single row is not found
  20. How to find out the MySQL root password
  21. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  22. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  23. Using index, using temporary, using filesort – how to fix this?
  24. How to restrict a column value in SQLite / MySQL
  25. How to get the max of two values in MySQL?
  26. How to connect locally hosted MySQL database with the docker container
  27. MySQL – SELECT * INTO OUTFILE LOCAL ?
  28. how to partition a table by datetime column?
  29. MySQL errorno 121
  30. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?

Leave a Comment