I coulda sworn - but if you say this works, I'm wrong. :)
On Thu, Mar 20, 2008 at 5:19 PM, Dan Vega <[EMAIL PROTECTED]> wrote:
> You sure about that Ray? I just ran this and it ran ok for me.
>
> <cfwindow initshow="true" center="true"
> width="430" height="340" title="Artists">
>
> <cfform>
> <cfgrid name="artists" format="html" pagesize="10" striperows="yes"
> selectmode="edit" delete="yes"
> bind="cfc:artists.getArtists
>
> ('one',{cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
> onchange="cfc:artists.editArtist
> ({cfgridaction},{cfgridrow},{cfgridchanged})">
> <cfgridcolumn name="is" display="false" />
> <cfgridcolumn name="lastname" header="Last Name" width="100"/>
> <cfgridcolumn name="firstname" header="First Name" width="100"/>
> <cfgridcolumn name="email" header="E-Mail" width="200"/>
> </cfgrid>
> </cfform>
>
> </cfwindow>
>
>
> <cffunction name="getArtists" access="remote" returntype="struct">
> <cfargument name="test" type="string" required="true">
> <cfargument name="page" type="numeric" required="yes">
> <cfargument name="pageSize" type="numeric" required="yes">
> <cfargument name="gridsortcolumn" type="string" required="no"
> default="">
> <cfargument name="gridsortdir" type="string" required="no" default="">
>
> <!--- Local variables --->
> <cfset var artists="">
>
> <!--- Get data --->
> <cfquery name="artists" datasource="cfartgallery">
> SELECT artistid, lastname, firstname, email
> FROM artists
> <cfif ARGUMENTS.gridsortcolumn NEQ ""
> and ARGUMENTS.gridsortdir NEQ "">
> ORDER BY #ARGUMENTS.gridsortcolumn# #ARGUMENTS.gridsortdir#
> </cfif>
> </cfquery>
>
> <!--- And return it as a grid structure --->
> <cfreturn QueryConvertForGrid(artists,
> ARGUMENTS.page,
> ARGUMENTS.pageSize)>
> </cffunction>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301727
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
