Genevieve
|
Posted: 10/22/2003, 7:01 AM |
|
Hi,
I'm new to ccs, im using asp templates and an access database.
I have littles problems as i was new to database too.
In my database, i have a field that are a hyperlink (ex.:www.blabla.com). I will have the hyperlink visible only when there is something in that field and of course have the hyperlink working...
Second problem, i have to publish a long text but im limited to 255 caracters in access for the field size. Any tips on how to include a text larger than 255 caracters?
Thanks a lot in advance.
I hope i will have some answers...hehe
|
|
|
ryan
|
Posted: 10/22/2003, 7:53 AM |
|
instead of text(255) use memo data type, however limit your memo usage to just 2 to 3 fields i personally would not want an elephant sized data for Access
for showing hyperlink i assume ur in the grid like
{link}--------{anotherfield}------{andanotherfield}
on the {link} place ur mouse cursor there (I'm talking CCS IDE now) and go to the before show event of that label.
On the code of the link write this
'Write ur code here
IF IsEmpty (THEformname.link.value) Then THEformname.link.visible = false
Now THEformname is your form name what is the grid name? And the link is the link name.
:)
|
|
|
Genevieve
|
Posted: 10/22/2003, 10:58 AM |
|
Thanks Ryan for your help.
Ok i have changed the text field for memo field. I put also the code for the link it work.
But i still have a problem that my link do not redirect me to the specified page (ex.: www.gotocode.com). When i click on my link, i have the path where my pages are (ex.: 205.510.xxx.xxx../blabla/blabla/www.gotocode.com)
Thanks again, i appreciate a lot :)
Gene
|
|
|
ryan
|
Posted: 10/22/2003, 4:00 PM |
|
try this on the before show link event
IF IsEmpty (THEformname.link.value) Then
THEformname.link.visible = false
ELSE
THEformname.link.value = "http://" & THEformname.link.value
END IF
now go the properties window of that link and chenge the content from Text to HTML like below :
Name
Control Source
control Source Type
Data Type
Default Value
Content------------------HTML
DBFormt
|
|
|
|