CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Key transfer doesn't work!?

Print topic Send  topic

Author Message
Yogi
Posted: 02/16/2001, 1:17 AM

Hi there,

How can I transfer a key
What I tried to achieve on my system Apache/mySQL/PHP:
1. User logs in - works
2. User Data is shown and can be edited - works
3. Show all user with same... e.g. age... - Doesn't work
He tells me no records! But I think I did everything like in the example
selction of pk ... transfer ... required ...

What are the most important tasks to do to make it work!? Any special
variable names, or ...!?
Any help!?

Yogi

Alexey Alexapolsky
Posted: 02/16/2001, 3:07 AM

To show users with the same age you will need :
1) to click on "Form properties" icon , select Input tab ,
add input variable , e.g. age
Also make sure that this "age" is present on a form , that refers to
this form. That's all
Note : if age is of URL type , you need to add variable to Output tab.

2) If this age is a contant you can :
to click on "Form properties" icon , select SQL tab ,
and type in your sql , like : select * from users where age=25


--
Regards,
Alexey
CodeCharge Support

Yogi <eder@berkom.de> wrote in messagenews:96ir7t$kfl$1@news.codecharge.com...
> Hi there,
>
> How can I transfer a key
> What I tried to achieve on my system Apache/mySQL/PHP:
> 1. User logs in - works
> 2. User Data is shown and can be edited - works
> 3. Show all user with same... e.g. age... - Doesn't work
> He tells me no records! But I think I did everything like in the example
> selction of pk ... transfer ... required ...
>
> What are the most important tasks to do to make it work!? Any special
> variable names, or ...!?
> Any help!?
>
> Yogi
>
>

CodeCharge
Posted: 02/16/2001, 5:08 AM

The key is usually used to select 1 specific record.
If you want to select users with the same age, you probably shouldn't try to
transfer the key.

In general, to transfer the key, you'd need to specify the "Output" in Field
Properties of the initial form, and specify the "Input" in Form Properties
of the destination form. You have to use matching variable names in both
Output and Input.

To select all records with specific age, etc., use WHERE clause in Form
Properties. For example "age=25".



Yogi <eder@berkom.de> wrote in messagenews:96ir7t$kfl$1@news.codecharge.com...
> Hi there,
>
> How can I transfer a key
> What I tried to achieve on my system Apache/mySQL/PHP:
> 1. User logs in - works
> 2. User Data is shown and can be edited - works
> 3. Show all user with same... e.g. age... - Doesn't work
> He tells me no records! But I think I did everything like in the example
> selction of pk ... transfer ... required ...
>
> What are the most important tasks to do to make it work!? Any special
> variable names, or ...!?
> Any help!?
>
> Yogi
>
>


   


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.