The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
<cfquery name <cfif
Hello,
I have this Data into my SQL Table TblDataInfo.
Example of my data:
Data_ID: 10254
user_submitted: 1
user_date_submitted: 2013-01-4 13:10:10.707
User_Confirmation: DATA-16687-20120104011007
id_number: 2432
Data_year: 2011-2012
SELECT [Data_id]
,[user_submitted]
,[user_date_submitted]
,[user_confirmation]
,[id_number]
,[Data_year]
FROM [ABC].[dbo].[tblDATAInfo]
where id_number like '2432'
My Question:
------------------------
<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.use
SELECT * FROM tblDATAInfo
WHERE (id_number = #client.user_id#) and
(Data_Year = '2011-2012')
</cfquery>
Then my coldfusion code will be:
<cfif .....
I have this Data into my SQL Table TblDataInfo.
Example of my data:
Data_ID: 10254
user_submitted: 1
user_date_submitted: 2013-01-4 13:10:10.707
User_Confirmation: DATA-16687-20120104011007
id_number: 2432
Data_year: 2011-2012
SELECT [Data_id]
,[user_submitted]
,[user_date_submitted]
,[user_confirmation]
,[id_number]
,[Data_year]
FROM [ABC].[dbo].[tblDATAInfo]
where id_number like '2432'
My Question:
------------------------
<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.use
SELECT * FROM tblDATAInfo
WHERE (id_number = #client.user_id#) and
(Data_Year = '2011-2012')
</cfquery>
Then my coldfusion code will be:
<cfif .....
Asked:
-
6
4
1 Solution
_Agx, Happy New Year.
Could you please fix my query ?
<cfquery name="DisplayButtons" datasource="ABC" username="#application.use
SELECT * FROM tblDATAInfo
WHERE (id_number = #client.user_id#) and
(Data_Year = '2011-2012')
</cfquery>
Could you please fix my query ?
<cfquery name="DisplayButtons" datasource="ABC" username="#application.use
SELECT * FROM tblDATAInfo
WHERE (id_number = #client.user_id#) and
(Data_Year = '2011-2012')
</cfquery>
Once my querry is correct what <CFIF i should put before the button.
<p align="center"><a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a></p>
<p align="center"><a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a></p>
In order for the button to disappear, you would need to develop code that would check that table for the member's ID number and the 2011-2012 data in the same record, for the button to NOT display. You need to use both fields since there is data in that table from previous years. Let me know if that's not clear.
This is what it should look like. You just need to pass in the right year. Let me know if you need help with that part.
<!--- check for existing records for year 2011-2012 --->
<cfquery name="DisplayButtons" datasource="ABC" username="#application.use
SELECT id_number
FROM tblDATAInfo
WHERE id_number = <cfqueryparam value="#client.user_id#" cfsqltype="cf_sql_integer"
AND Data_Year = <cfqueryparam value="2011-2012" cfsqltype="cf_sql_varchar"
</cfif>
<!---- If no records were found, go ahead and show the button ---->
<cfif DisplayButtons.recordCount
<p align="center">
<a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a>
</p>
</cfif>
<!--- check for existing records for year 2011-2012 --->
<cfquery name="DisplayButtons" datasource="ABC" username="#application.use
SELECT id_number
FROM tblDATAInfo
WHERE id_number = <cfqueryparam value="#client.user_id#" cfsqltype="cf_sql_integer"
AND Data_Year = <cfqueryparam value="2011-2012" cfsqltype="cf_sql_varchar"
</cfif>
<!---- If no records were found, go ahead and show the button ---->
<cfif DisplayButtons.recordCount
<p align="center">
<a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a>
</p>
</cfif>
Hello Agx,
Your code didn't work. I did the following code and it's working.
I have a question for you, how i'm able to reverse the CFistatement
<cfif DisplayUser.DATA_submitted
<cfelse>
<p align="center">
<a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a></cfif>
Your code didn't work. I did the following code and it's working.
I have a question for you, how i'm able to reverse the CFistatement
<cfif DisplayUser.DATA_submitted
<cfelse>
<p align="center">
<a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a></cfif>
Oh, I thought you wanted to display the button if the record *didn't* exist. If it's the other way around, then your code is right. Though to be safe you might use GTE 1. So it'll still work if there's ever more than 1 record.
> <cfif DisplayUser.DATA_submitted eq 1>
Oh wait a minute ... ignore my last comment. I see the problem. You're not using the recordCount like in my example. It should be this instead:
<cfif DisplayButtons.recordCount eq 0>
<p align="center">
<a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a>
</cfif>
Oh wait a minute ... ignore my last comment. I see the problem. You're not using the recordCount like in my example. It should be this instead:
<cfif DisplayButtons.recordCount eq 0>
<p align="center">
<a href="http://www.abc.com"><img src="mybutton.jpg" width="100" height="50" border="0"></a>
</cfif>
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Be seen. Boost your question’s priority for more expert views and faster solutions
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
<cfif DisplayButtons.recordCount
show the button
</cfif>
(Also, it's a good practice to always use cfqueryparam to prevent sql injection. Edit Not sure of your data types, but something like this: )
Open in new window