John Thorne
|
| Posted: 04/20/2002, 6:08 AM |
|
Page navigation total record is what
A search returns a grid with Previous [1 2 of 2] Next Last
How can I also show 43 records of 234?
Page navigation show total record count is what I'd like
What determines the "sort" link on found records?
Say I have 7 fields ID ABC CDE EDF HIJ Date1 Date2
When I select allow sorting the only fields that have a "sort" link
are ID Date1 and Date2
thanks in advance
jrt
|
|
|
 |
John Thorne
|
| Posted: 04/20/2002, 6:09 AM |
|
Working with php mySQL
"John Thorne" <john@jrthorne.com> wrote in message
news:a9rp7o$2th$1@news.codecharge.com...
> Page navigation total record is what
> A search returns a grid with Previous [1 2 of 2] Next Last
> How can I also show 43 records of 234?
> Page navigation show total record count is what I'd like
>
> What determines the "sort" link on found records?
>
> Say I have 7 fields ID ABC CDE EDF HIJ Date1 Date2
>
> When I select allow sorting the only fields that have a "sort" link
> are ID Date1 and Date2
>
> thanks in advance
>
> jrt
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 04/22/2002, 2:32 AM |
|
1) To show navigation the way you want you should open
Form Properties/Events/Custom navigation , obtain generated code
and modify it to display desired info.
2) A slow and awkward workaround would be to replace such params
as FormMessages_Sorting in template body in "Custom show page" event
a sketch could be like below :
$document = GetVar("main");
$document = do_replace($document);
set_var("main",$document)
--
Alex
CodeCharge Developer
"John Thorne" <john@jrthorne.com> wrote in message
news:a9rp7o$2th$1@news.codecharge.com...
> Page navigation total record is what
> A search returns a grid with Previous [1 2 of 2] Next Last
> How can I also show 43 records of 234?
> Page navigation show total record count is what I'd like
>
> What determines the "sort" link on found records?
>
> Say I have 7 fields ID ABC CDE EDF HIJ Date1 Date2
>
> When I select allow sorting the only fields that have a "sort" link
> are ID Date1 and Date2
>
> thanks in advance
>
> jrt
>
>
|
|
|
|
John Thorne
|
| Posted: 04/23/2002, 8:41 AM |
|
Sorting Grid..
When I added Date fields to the grid, CC provided the "sort link" on the
field label
I was able to add the code on the php page:
if ($iSort == 1) $sOrder = " order by A.ABC" . $sDirection;
if ($iSort == 2) $sOrder = " order by A.CDE" . $sDirection;
if ($iSort == 3) $sOrder = " order by A.FGH" . $sDirection;
if ($iSort == 4) $sOrder = " order by A.IJJ" . $sDirection;
html page:
<a href="{FileName}?{FormParams}FormAnimalData_Sorting=1 ##increment this
thru 4## &FormData_Sorted={Form_Sorting}&"><font >ID</font></a></td>
and get all the fields to sort.
How does CC determine which fields to "allow sorting" ?? Can I do something
that will produce the sort links automatically without
having to manually edit this code?
Record xxx of xxx
I seen where to get the navigation code.
Can you give me an example of the code I need to show record counts (12 of
214 etc...)
thanks
jrt
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:aa0lc3$kcv$2@news.codecharge.com...
> 1) To show navigation the way you want you should open
> Form Properties/Events/Custom navigation , obtain generated code
> and modify it to display desired info.
>
> 2) A slow and awkward workaround would be to replace such params
> as FormMessages_Sorting in template body in "Custom show page" event
>
> a sketch could be like below :
>
> $document = GetVar("main");
> $document = do_replace($document);
> set_var("main",$document)
>
>
> --
> Alex
> CodeCharge Developer
>
>
> "John Thorne" <john@jrthorne.com> wrote in message
>news:a9rp7o$2th$1@news.codecharge.com...
> > Page navigation total record is what
> > A search returns a grid with Previous [1 2 of 2] Next Last
> > How can I also show 43 records of 234?
> > Page navigation show total record count is what I'd like
> >
> > What determines the "sort" link on found records?
> >
> > Say I have 7 fields ID ABC CDE EDF HIJ Date1 Date2
> >
> > When I select allow sorting the only fields that have a "sort" link
> > are ID Date1 and Date2
> >
> > thanks in advance
> >
> > jrt
> >
> >
>
>
|
|
|
|
