CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Adjustable Rows

Print topic Send  topic

Author Message
PeterJ


Posts: 90
Posted: 06/07/2004, 3:49 AM

Can anyone direct me toward advice on how to allow users to move grid rows up or down? I have seen somewhere, sometime ago a page where the visitor can move a row up or down a grid at the click of an arrow in a column.

Thanks
View profile  Send private message
ghtracey

Posts: 23
Posted: 06/07/2004, 12:43 PM

A grid is ordered based on the queries ORDER BY, or by the Sorters. If you are trying to control the ordering as you describe, you would need a field to control that. You would then have to code an SQL update that would renumber the entire result set based on whether the record should be moving up or down. Off the top of my head, I can't think of an easier way to do this.
_________________
Graham Tracey
Council of Yukon First Nations
View profile  Send private message
PeterJ


Posts: 90
Posted: 06/07/2004, 11:18 PM

Hi

I can achieve what you describe but what I have seen ( and I'm kicking myself for not recording where I saw it!) was an 'up' and 'down' arrow in the right margin of the table and this allowed users to move (prioritize) rows.
View profile  Send private message
Nizzan
Posted: 06/10/2004, 9:13 AM

You mean in Postnuke administration panel?

"PeterJ" <PeterJ@forum.codecharge> wrote in message
news:540c55a4108f9f@news.codecharge.com...
> Hi
>
> I can achieve what you describe but what I have seen ( and I'm kicking
myself
> for not recording where I saw it!) was an 'up' and 'down' arrow in the
right
> margin of the table and this allowed users to move (prioritize) rows.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

nathan
Posted: 06/10/2004, 9:15 AM

If that happens in client side you must use JavaScript. :)
Sam Powell
Posted: 06/16/2004, 8:36 AM

Peter,

I've done that on my website to allow users to prioritize the order in which a menu will be displayed. If you are interested send me an email and I will forward to you a zip file of the code.

Send email request tosam@fastrax.net

Regards, Sam
Sam Powell
Posted: 06/21/2004, 8:55 AM

Peter,

I received and replied to your messages however they continue to return to me undelivered.

I replied to apis@globalnet.co.uk

Do you have a different email I can use?

Regards, Sam

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.