Interview Question in SQL Server Indexing
Interview Question :: Coldfusion when select value display records with that value
Hey Everyone,
I have asked this question before but i am just not understanding. What i am trying to do is at the top i am going to have links. The links are to the values that appear under the field status in my ticket table on my sql server. So for example in my status field i have the value Open. At the top you will see Open an when you click on Open below in the table (where all the records are displayed) it will only display records with the value of Open . But i can not seem to get the link part of this working.
right now this is what i been trying to do
ticket holds are all the records
<cfquery name="ticket" datasource="CustomerSupport">
SELECT pk_ticketID,status,title,
date_last_modified,date_submitted,cust...
FROM
dbo.tbl_CS_ticketMaster
</cfquery>
this is the link at top which the user should click.
<cfoutput>
<a href="index.cfm?status=#Open#>Open</a>
</cfoutput>
where all the records will be displayed
<cfoutput query="ticket"></cfoutput>
if someone could explain to me what i am doing wrong i would really appreciate it :).
Thank you in advance,
Rach
Loading ...