Variable in Query

Google is your freind. I am not.

To find information about a cold fusion tag, search on "<cftagname> x" where x is the version of cold fusion you are running. Include the angle brackets in your search.

To find information about a cold fusion function, search on "coldfusion name_of_function x". Note that coldfusion is one word.

Almost always, the first pages offered will be right out of the cfml reference manual.

The name of the tag is cfargument.

Ok I kinda understand. I'm to new to this and Dreamweaver. OK the field year in the database are numeric. I replaced the 2007 with #arguments.playeryear#. Now adding cfargument tag where and how do I do that.

Thanks for your help.

If you want it to be a function, add a cfargument tag to that function to accept the year. Make it numeric. Then, in your query, replace the "2007" with #arguments.playeryear#.

Now, about those quotes. First, when submitting queries through odbc/jbdc you single quotes, not double quotes. Secondly, quotes only apply to char/varchar datatypes. Why would a field that could only accept numbers not be numeric?

To run the query, put an anchor tag around the years with a url variable. On the page that is linked to, call your function and send the url variable as an argument.