Here is an example I found on www.cfform.com so I hope it helps. I was able to integrate it into my code and make it work.
<cfif isDefined("url.user_id")>
<cfoutput>
<p>The selected userid is: #url.user_id#</p>
</cfoutput>
</cfif>
<cfscript> myData = queryNew("id,name")...
Here is a piece of code that will allow you to specify a column that you are looking for and tell you all the tables that the column appers in.
CREATE PROCEDURE [spColumnsInTableNew] @columnName varchar(50)
AS
select sc.name as ColumnName, so.name as TableName
from syscolumns as SC inner join...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.