search result

[david s]

Hello,

i need to know how to do this:

Unique search on custom web publishing that reports in the result page the number of records related to categories.

Something like:

pictures (2)

video (3)

text (1)

The db is organized with a field called "category" in wich i put (pictures or video or text).

Thanks and have a good day

[Keith M. Davie]

First off, storing the pictures and videos in the container field is going to eat a lot of memory for the application and probably slow down some of the serving.

Next, you are storing either text or pix or vids in one field. You are going to need a calculation of some sort which will be able to discern what is in the field of a given record. You can then figure how to get your count from that calc field.

You may need to redesign your solution.