Binding CFGrid and Query MX7

[Anthony Brown]

Hello-
I was playing around with flash forms in MX7. I want to bind a quesry to a cfgrid. I looked at the demo on the MM site, and am trying to do the basic scripting just to see how it works.

I keep getting an error saying that the value of query="client" is invalid.

Sample code:

<cfquery name="client" datasource="test">
SELECT Contact_Name, Contact_EMail, WebsiteURL FROM billing_clienttb ORDER BY Company_Name ASC
</cfquery>

<cfform format="flash" width="500" skin="haloBlue">

<cfgrid name="grid" query="client" selectmode="single">

<cfgridcolumn name="Contact_Name">
<cfgridcolumn name="Contact_Email">
<cfgridcolumn name="WebsiteURL">

</cfgrid>

</cfform>

What am I doing wrong?


Thxs,
Anthony

[Anthony Brown]

Figured it out.
Apparently I can't use client as a RS name. Changed it to clientrs and it works now.

Darn reserved words...lol


"Anthony Brown" <anthony@kermy.com> wrote in message news:d2ccfu$su6$1@forums.macromedia.com...
Hello-
I was playing around with flash forms in MX7. I want to bind a quesry to a cfgrid. I looked at the demo on the MM site, and am trying to do the basic scripting just to see how it works.

I keep getting an error saying that the value of query="client" is invalid.

Sample code:

<cfquery name="client" datasource="test">
SELECT Contact_Name, Contact_EMail, WebsiteURL FROM billing_clienttb ORDER BY Company_Name ASC
</cfquery>

<cfform format="flash" width="500" skin="haloBlue">

<cfgrid name="grid" query="client" selectmode="single">

<cfgridcolumn name="Contact_Name">
<cfgridcolumn name="Contact_Email">
<cfgridcolumn name="WebsiteURL">

</cfgrid>

</cfform>

What am I doing wrong?


Thxs,
Anthony