Mark Leavesley
|
| Posted: 09/01/2003, 3:05 PM |
|
Hi,
I recently downloaded CCS to see if such tools have finally evolved to a
point of being usable for anything more than a simple flat database. So far,
I'm impressed and I'm sure that many of my problems are simply lack of
familiarity with the product.
I've had a quick scan of this ng as well as the website FAQ and I can't find
an answer to this problem.
I have a page that displays summary content from an Access table, some of
the fields contain vast text entries and I need to limit this to say 100
characters. As I may at some point switch from ASP to .NET I am reluctant to
actually write any code and would rather that CCS would do it for me. Any
ideas? I've seen the 'format' property but there is no mention of how it is
used, though I'm guessing regular expressions which I'm not very familiar
with.
Thanks,
Mark Leavesley
|
|
|
 |
DonB
|
| Posted: 09/01/2003, 4:17 PM |
|
One way is to do a "SELECT LEFT(some_col, num_chars) FROM some_table", which
means you chnage the Textbox (or whatever Control use use) to have a
Datasource Type of "Database Expression" and put the "LEFT(...)" function
into the Datasource (instead of merely specifying the column name).
The other way is to create a "Query" in Access and put the LEFT function in
there (which means you don't have to use a Database Expression in CCS).
The second way is cleaner, I think.
Have a look at my site, there are a number of hints and tips there that may
be useful to you.
--
DonB
http://www.gotodon.com/ccbth
"Mark Leavesley" <b-bandit@NOSPAN.freeuk.com> wrote in message
news:bj0fra$irn$1@news.codecharge.com...
> Hi,
>
> I recently downloaded CCS to see if such tools have finally evolved to a
> point of being usable for anything more than a simple flat database. So
far,
> I'm impressed and I'm sure that many of my problems are simply lack of
> familiarity with the product.
>
> I've had a quick scan of this ng as well as the website FAQ and I can't
find
> an answer to this problem.
>
> I have a page that displays summary content from an Access table, some of
> the fields contain vast text entries and I need to limit this to say 100
> characters. As I may at some point switch from ASP to .NET I am reluctant
to
> actually write any code and would rather that CCS would do it for me. Any
> ideas? I've seen the 'format' property but there is no mention of how it
is
> used, though I'm guessing regular expressions which I'm not very familiar
> with.
>
>
> Thanks,
> Mark Leavesley
>
>
|
|
|
|
|
