JimmyCrackedCorn
Posts: 583
|
| Posted: 06/19/2008, 10:10 PM |
|
I'm using the CCS Calendar Builder and it creates a nice calendar with both the event time and the event description placed right on the proper day of the calendar. But I need to add a link to each event that takes you to another page with details about the event.
Inside my table (named Events) are the following fields for each event,
EventID
EventName
EventDate
EventTime
EventDescription
The CCS Calendar already gets the EventName, EventTime and EventDate fields. But, to add a link, I need to also get the EventID field. Any ideas as to how to get this?
I thought of using this inside the EventName_BeforeShow event,
varEventID = CCDLookUp("EventID","Events","EventName=" & "'" & Events.EventName.Value & "'",DBConnection1)
But the problem there is the EventName field is not unique. Likewise, the EventDate and EventTime fields are not unique.
I really need some way to get the EventID field.
_________________
Walter Kempees...you are dearly missed. |
 |
 |
JimmyCrackedCorn
Posts: 583
|
| Posted: 06/19/2008, 10:24 PM |
|
Nevermind. I figured it out. Very simple actually...just add a hidden field and connect it to the EventID column in the database!! Doh! :)
_________________
Walter Kempees...you are dearly missed. |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/20/2008, 2:22 AM |
|
Are you starting to like the calender then?
http://www.dubbellul.nl/calendar
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
|
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 06/20/2008, 11:00 AM |
|
yeah, I'm actually pretty thrilled with it!! but, as usual, any time I use a new feature with CCS I go through the following stages,
1) excitement to try out the new feature
2) frustration because I cannot figure out how to use the new feature
3) anger at Yes for not having complete documentation
4) acceptance that it is what it is
5) a thrill when I figure out how to get it done
6) complete satisfaction when I get it working and again realize what an awesome tool CCS is!
_________________
Walter Kempees...you are dearly missed. |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/20/2008, 6:52 PM |
|
Calendar Component in Design Mode.
Select EventName (id that is what you display, right click, change to link.
Link parameters as in all other Components.....
D not forget the parameter tab, DatSource Column, event_id.....
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
|
|
|
|
|
