Can i use SQL for get information of my calendar?

[Robertiger]

i have copy of my database in a .sql file, and i loaded this in MySQL server in linux system,
i’m trying to get information about it with queryes, but i think that the information is incorrect or that the information is codified because some fields have strange data, I find a line of my sql file like this, where the data is inserted:

INSERT INTO egw_cal VALUES (48,‘calendar-48-be6b32103e6933deef9064758cd703e0’,67,’’,1187980267,2,0,‘Usuario’,‘Rosales y Victor con usuario, tal vez vaya’,’’,0,47,0,0)

I know that egw_cal is a column of my table, but the others fields are unknown for me.
i have to do a cast? what kind of cast?
Do you know where i can find more information?

[ngegw]

i have copy of my database in a .sql file, and i loaded this in MySQL server
in linux system,
i’m trying to get information about it…

INSERT INTO egw_cal VALUES
(48,‘calendar-48-be6b32103e6933deef9064758cd703e0’,67,’’,1187980267,2,0,‘Usuario’,‘Rosales
y Victor con usuario, tal vez vaya’,’’,0,47,0,0)

I know that egw_cal is a column of my table, but the others fields are
unknown for me.

egw_cal is a table in your database, each column is in VALUES()
seperated by a comma.

i have to do a cast? what kind of cast?

No cast is required, all the data is of the correct type.
Exactly what information are you trying to find, or what are you
trying to accomplish? Some of those columns are references to other
tables.

---

Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Manfred_Kiss]

Hi
Robertiger

1187980267

for example is a unixtimestamp
see http://www.4webhelp.net/us/timestamp.php

there are more tables involved like cal_dates

see in your db-schema. Regard all tables egw_cal*

Kind regards

Manfred

i have copy of my database in a .sql file, and i loaded this in MySQL server in linux system,
i’m trying to get information about it with queryes, but i think that the information is incorrect or that the information is codified because some fields have strange data, I find a line of my sql file like this, where the data is inserted:

INSERT INTO egw_cal VALUES (48,‘calendar-48-be6b32103e6933deef9064758cd703e0’,67,’’,1187980267,2,0,‘Usuario’,‘Rosales y Victor con usuario, tal vez vaya’,’’,0,47,0,0)

I know that egw_cal is a column of my table, but the others fields are unknown for me.
i have to do a cast? what kind of cast?
Do you know where i can find more information?