I use to be a bit of a wiz at coldfusion 4, but I havent used it in quite a WHILE! Now its at version 7 and what I remember doesnt seem to work anymore...
I am trying to write a 'news' page, it takes data from two tables... news and users.
It will display the title and story from the news table and the username from the users table. The two tables will be joined by the userid which is the same in both tables....
Here is my query, that use to work in old version 4!
<cfquery datasource=#db# name=test> SELECT * FROM news, users WHERE news.userid = users.userid </cfquery>
But it just comes up with this error:
Error Executing Database Query.
Type mismatch in expression.
The error occurred in C:\CFusionMX7\wwwroot\cfdocs\jericho\index.cfm: line 1
1 : <cfquery datasource=#db# name=test>
2 : SELECT *
3 : FROM news, users
Any help would be greatly appreciated, and once I have got over this rather easy milestone, I will be able to get on with it!