Question
CFQuery Issues
I'm trying to get data from a coldfusion database , with to start with, a very basic query.
I'm running this code :
<cfquery name="GetDatabaseSearchResults" DateSource="durhamli_durhamli">
SELECT *
FROM durhamli_DLI.SixthDLI
WHERE `Pre1917ServiceNumber` ='1'
</cfquery>
and getting this error :
The error occurred in ********* : line 8
6 :
7 : <body>
8 : <cfquery name="GetDatabaseSearchResults" DateSource="durhamli_durhamli">
9 :
10 : SELECT *
When I use the SQL direct on the database it pulls in a query fine.
When I check the DSN I get
| Data Source Name | Database Name | Type | Server / Port | Created | |
| durhamli_durhamli | durhamli_DLI | MYSQL5 | localhost:3306 |
| OK : The DNS durhamli_durhamli has connected to the database! |
Can anyone tell me where I'm going wrong ? (Ive not used CF for a good few years)
AdChoices