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
>
>
|
|
|
|
|
