<cfquery name <cfif
Posted on 2013-01-04
I have this Data into my SQL Table TblDataInfo.
Example of my data:
user_date_submitted: 2013-01-4 13:10:10.707
where id_number like '2432'
<p align="center"><a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a></p>
I would like to add a coldfusion code before the button image so that it disappears from my page, once a user has filed the data. This would involve putting some code around the button "mybutton.jpg" that would check the tblDataInfo table for the member's ID number and the Data_year=2011-2012 (in the same record), which is what gets stored in the table (along with some other info), once the member files.
Now, I have a coldfusion page who display that image button. So I don't want to display the button every time on that page when the user logged again... because he already filled the forms.
So could you please helpm in this , what my new querry should be something like this ?
<cfquery name="DisplayButtons" datasource="ABC" username="#application.username#" password="#application.password#">
SELECT * FROM tblDATAInfo
WHERE (id_number = #client.user_id#) and
(Data_Year = '2011-2012')
Then my coldfusion code will be: