cfcquery invalid attribute

[gerendula]

have cfquery error message advising invalid attribute

how do u determine correctattribute to use

 

[FALCONSEYE]

can u post your cfquery tag?

http://www.jetansolutions.com

 

[TamedTech]

The best way to check for valid attirbutes is to type cfquery into google, the top link is usualy the Macromedia LiveDocs, that will explain the tag and all its attributes.

This same process can be used for most of the CF Tags.

But as far as a query is concerned, a basic cfquery should contain 2 attributes, 1st should be 'name' this will be used to referance the query result when you output it, secondly set a 'datasourse' which is the name of your Datasource set in coldfusion administrator panel.

So, i have a datasource called 'mydatabase' so my basic query and output looks like this.

<cfquery name="query1" datasource="mydatabase">
SELECT * FROM tablename
</cfquery>

<cfoutput query="query1">
#field1# and #field2#
</cfoutput>

Let us have a look at your code and we'll be able to help more.

Rob

 

[r937]

macromedia livedocs? eeee

http://wwwwwww

that has gotta be one of the slowest sites on the entire internet (i think it's because they use so much "rich content" [ugh])

here's a much nicer resource --

http://www.techfeed.net/cfQuickDocs/

check out the "how it works" link -- the site uses ajaxCFC



r937.com | rudy.ca

 

[TamedTech]

Woo ... nice find r937, i've not come accross that one before, thanks very much, that'll be top of my favourites list.

You're right, Livedocs is slow, i've just found it usefull as a quick referance to tags, but this new one could well be what i need.

If you're new to CF gerendula, you may want to check out some CF Tutorials, some of the most usefull ones i have found have been on

http://www.easycfm.com,

also Kevin from these boards has his site, the link for which i dont have to hand which is also an excelent resource.

Rob