I have a question about passing variables. Can someone help me?
Thanks in advance!
Is it possible to pass two variables to the same page at the same time like this or can you give me the correct syntax:
Here is the part of code:
<cfquery datasource="datacat" name="data1">
SELECT DQ_Source.Source_ID, ID.Dataset_ID, CI.Citation_ID, CI.Citation_ID, CI.Originator_Names, CI.Publication_Date, CI.Publication_Time, TP_Date.Year, TP_Date.Hour, TP_Date.Minute, TP_Date.Second
FROM (ID INNER JOIN (CI INNER JOIN DQ_Source ON CI.Citation_ID = DQ_Source.Citation_ID) ON ID.Dataset_ID = DQ_Source.Dataset_ID)
WHERE (((ID.Dataset_ID)=#Dataset_ID#))
</cfquery>
<cfoutput query="data1">
----
----
---
</cfoutput>
<!---Here is i am having problem>
<a href="citaddedit.cfm?Citation_ID=<cfoutput>#data1.Citation_ID# & citaddedit.cfm?Dataset_ID=#Dataset_ID#</cfoutput></a>
Thanks in advance!
Is it possible to pass two variables to the same page at the same time like this or can you give me the correct syntax:
Here is the part of code:
<cfquery datasource="datacat" name="data1">
SELECT DQ_Source.Source_ID, ID.Dataset_ID, CI.Citation_ID, CI.Citation_ID, CI.Originator_Names, CI.Publication_Date, CI.Publication_Time, TP_Date.Year, TP_Date.Hour, TP_Date.Minute, TP_Date.Second
FROM (ID INNER JOIN (CI INNER JOIN DQ_Source ON CI.Citation_ID = DQ_Source.Citation_ID) ON ID.Dataset_ID = DQ_Source.Dataset_ID)
WHERE (((ID.Dataset_ID)=#Dataset_ID#))
</cfquery>
<cfoutput query="data1">
----
----
---
</cfoutput>
<!---Here is i am having problem>
<a href="citaddedit.cfm?Citation_ID=<cfoutput>#data1.Citation_ID# & citaddedit.cfm?Dataset_ID=#Dataset_ID#</cfoutput></a>