CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Record Builder: how to build the form dynamically from a query

Print topic Send  topic

Author Message
moldinaga

Posts: 4
Posted: 02/19/2005, 8:04 PM


Hi. I'm medium new at codecharge.

I'll simplify the problem for this illustration:

Let's say I have a table of items, containing fields ID (key), quantity, and weight.

ID Quantity Weight
1 5 22
2 18 21

whatever. Okay, to make a record form to deal with that info is no sweat. But my problem is that I have another table of labels for these items. Names in many languages....like this: (assume 1 is english, 2 spanish, 3 german)

ID LANGID Name
1 1 Water
1 2 Agua
1 3 Wasser
2 1 Beans
2 2 Frijoles (spanish)
2 3 Bohnen


Anyway, forget about the beans and the water, those just happen to be words I speak in many languages (I keep my diet simple when I travel) The problem is that I want to make a recordedit page that is passed one param, the ID as a GET.

And I want the form to be kind of like this:
----------------------------------------------
Quantity: ___________
Weight: _____________
Labels
1: ___________
2: ____________
3: _____________

<submit>
-----------------------------------------------

now, to add to the confusion, there may be 1 or more different labels for a given item in the labels table. So for an item, there may be labels for it in 8 languages. And for others, only 2, or 1.

How can I dynamically generate the form fields? I mean, I know how to do it using raw php , but I want to do it in a way that is compatible with the record form, if possible. I'm comfortable with the custom inserts required (I think).

I just need a push in the right direction.

thanks fellas...

View profile  Send private message
Damian Hupfeld
Posted: 02/22/2005, 3:24 AM

Tis hard to do without refreshing the page...

Are you a registerred CCS user?

You can see something similar in the Example Pack 2 - its quite complex tho.
You run a grid/query in the <HEAD> section and use JS to modify your
dropdown lists....

Damian
http://www.nexthost.com.au/services.php


"moldinaga" <moldinaga@forum.codecharge> wrote in message
news:542180c452c84e@news.codecharge.com...
>
> Hi. I'm medium new at codecharge.
>
> I'll simplify the problem for this illustration:
>
> Let's say I have a table of items, containing fields ID (key), quantity,
> and
> weight.
>
> ID Quantity Weight
> 1 5 22
> 2 18 21
>
> whatever. Okay, to make a record form to deal with that info is no
> sweat.
> But my problem is that I have another table of labels for these items.
> Names
> in many languages....like this: (assume 1 is english, 2 spanish, 3 german)
>
> ID LANGID Name
> 1 1 Water
> 1 2 Agua
> 1 3 Wasser
> 2 1 Beans
> 2 2 Frijoles (spanish)
> 2 3 Bohnen
>
>
> Anyway, forget about the beans and the water, those just happen to be
> words I
> speak in many languages (I keep my diet simple when I travel) The problem
> is
> that I want to make a recordedit page that is passed one param, the ID as
> a
> GET.
>
> And I want the form to be kind of like this:
> ----------------------------------------------
> Quantity: ___________
> Weight: _____________
> Labels
> 1: ___________
> 2: ____________
> 3: _____________
>
> <submit>
> -----------------------------------------------
>
> now, to add to the confusion, there may be 1 or more different labels for
> a
> given item in the labels table. So for an item, there may be labels for
> it in
> 8 languages. And for others, only 2, or 1.
>
> How can I dynamically generate the form fields? I mean, I know how to do
> it
> using raw php , but I want to do it in a way that is compatible with the
> record form, if possible. I'm comfortable with the custom inserts
> required (I
> think).
>
> I just need a push in the right direction.
>
> thanks fellas...
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


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.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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