Prema
|
| Posted: 03/29/2008, 2:30 PM |
|
Hi People!
Could anyone help with some tips on how to use form values in parameters.
The issue is that our application needs to pass form values rather than
database values forward to another form, as the form format is required
rather than native MySQL format.
We're using CC4 with PHP5 and MySQL
We'd be grateful for any tips
Kind regards
Prema
|
|
|
 |
wkempees
Posts: 1679
|
| Posted: 03/29/2008, 3:56 PM |
|
I do not understand the problem??
If it is a Link you are trying to configure:
Parameters Tab, Press '+',
SourceType=Form,
ParameterSource is the name of the FormField you want to use ..... for instance Label1
ParameterName is the URL Parameter you are expecting on the receiving end.
Result is: http://domainname.tld/something.php?Parametername=(content of)Label1
The type Form generates a GetFromPost().
HTH
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
 |
|
prema
Posts: 6
|
| Posted: 03/29/2008, 4:28 PM |
|
Hi Walter ! Thanks very much for a near instant and helpful response!
Yes this is a link configuration.
The problem is that MySQL returns 2008-03-30 and the next form in the order process
wants a full date
Our approach is to try and use the already formatted date in the source form.
When we type the name of the form label field as Parameter Name, the value of the form label field doesn't appear in the get string or the recipient form.
Here is a portion of the get string showing that the DeliveryStartDate is empty
Here is a sketch of the Link Parameters Dialog:
Please view in a fixed-width font such as Courier.
+-------------------------------------------------+
| Link Parameter |
+-------------------------------------------------+
| |
| Source Type: |
| +---------------------------------------------+ |
| | Form | |
| +---------------------------------------------+ |
| Parameter Source: |
| +---------------------------------------------+ |
| | DeliveryStartDate | |
| +---------------------------------------------+ |
| Parameter name: |
| +---------------------------------------------+ |
| | DeliveryStartDate | |
| +---------------------------------------------+ |
| +---------------------------------------------+ |
| | | |
| | ?DeliveryStartDate={DeliveryStartDate}& | |
| | | |
| | | |
| | | |
| +---------------------------------------------+ |
| |
+-------------------------------------------------+
Does this clarify at all?
Thanks so much for your response
Kind regards
Prema
Quote wkempees:
I do not understand the problem??
If it is a Link you are trying to configure:
Parameters Tab, Press '+',
SourceType=Form,
ParameterSource is the name of the FormField you want to use ..... for instance Label1
ParameterName is the URL Parameter you are expecting on the receiving end.
Result is: http://domainname.tld/something.php?Parametername=(content of)Label1
The type Form generates a GetFromPost().
HTH
Walter
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 03/29/2008, 5:56 PM |
|
As a quick response, I would suspect that DeliveryStartDate is a Form Label.
It is not a TextBox, so it is not filled and therefore not Posted.
Hope you understand what I mean.
It is a bit like this:
You 'painted' the date from sql on the form (in a Label), When the Form is Submitted that data is NOT posted.
Right click your label, change it to a hidden field. That should do it.
Of course,m make sure the dateformat stays OK.
You could also do it directly in the Link Parameter setting, by doing a DateFormat.
But your approach is ok,
HaveFun
Walter
[ changing to SummerTime in 4 minutes......another lost hour and no summer weather to enjoy]
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Prema
|
| Posted: 03/29/2008, 9:49 PM |
|
Excellent looks like a couple of good leads there ! Thanks again for
the guidance. We'll post back when we sort it !
Kind regards
Prema
wkempees wrote:
> As a quick response, I would suspect that DeliveryStartDate is a Form Label.
> It is not a TextBox, so it is not filled and therefore not Posted.
> Hope you understand what I mean.
> It is a bit like this:
> You 'painted' the date from sql on the form (in a Label), When the Form is
> Submitted that data is NOT posted.
> Right click your label, change it to a hidden field. That should do it.
> Of course,m make sure the dateformat stays OK.
> You could also do it directly in the Link Parameter setting, by doing a
> DateFormat.
>
> But your approach is ok,
>
> HaveFun
>
> Walter
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
