Jeroen Steggink
|
| Posted: 03/28/2003, 3:09 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C2F587.875C2BF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I have an editable grid and it updates/deletes values in one table. But =
when one or more rows are deleted, rows in another table need to be =
deleted too. The rows in the other tables (manuals, keysets) are =
represented by a manual_id and key_id in the table used with the =
editable grid. So somehow I need to do some sort of a check when a row =
contains a manual_id or key_id and is deleted, the row with the =
corresponding id in keysets or manuals also has to be deleted. It's too =
bad that I can't use the multiple table delete because I have version =
3.23 and is only supported in version 4.
Does anyone have an idea how to solve my problem?
Jeroen Steggink
------=_NextPart_000_0014_01C2F587.875C2BF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have an editable grid and it =
updates/deletes=20
values in one table. But when one or more rows are deleted, rows in =
another=20
table need to be deleted too. The rows in the other tables (manuals, =
keysets)=20
are represented by a manual_id and key_id in the table used =
with the=20
editable grid. So somehow I need to do some sort of a check when a row =
contains=20
a manual_id or key_id and is deleted, the row with the corresponding id =
in=20
keysets or manuals also has to be deleted. It's too bad that I can't use =
the=20
multiple table delete because I have version 3.23 and is only supported =
in=20
version 4.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Does anyone have an idea how to solve =
my=20
problem?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jeroen =
Steggink</FONT></DIV></BODY></HTML>
------=_NextPart_000_0014_01C2F587.875C2BF0--
|
|
|
 |
Jeroen Steggink
|
| Posted: 03/28/2003, 3:44 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0029_01C2F58C.5DA583B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I forgot to tell I'm using CCS 2, with PHP and MySQL.
"Jeroen Steggink" <jeroen_steggink@hotmail.com> wrote in message =
news:b62ko6$43d$1@news.codecharge.com...
Hi,
I have an editable grid and it updates/deletes values in one table. =
But when one or more rows are deleted, rows in another table need to be =
deleted too. The rows in the other tables (manuals, keysets) are =
represented by a manual_id and key_id in the table used with the =
editable grid. So somehow I need to do some sort of a check when a row =
contains a manual_id or key_id and is deleted, the row with the =
corresponding id in keysets or manuals also has to be deleted. It's too =
bad that I can't use the multiple table delete because I have version =
3.23 and is only supported in version 4.
Does anyone have an idea how to solve my problem?
Jeroen Steggink
------=_NextPart_000_0029_01C2F58C.5DA583B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I forgot to tell I'm using CCS 2, with =
PHP and=20
MySQL.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeroen Steggink" <<A=20
=
href=3D"mailto:jeroen_steggink@hotmail.com">jeroen_steggink@hotmail.com</=
A>>=20
wrote in message <A=20
=
href=3D"news:b62ko6$43d$1@news.codecharge.com">news:b62ko6$43d$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have an editable grid and it =
updates/deletes=20
values in one table. But when one or more rows are deleted, rows in =
another=20
table need to be deleted too. The rows in the other tables (manuals, =
keysets)=20
are represented by a manual_id and key_id in the table used =
with the=20
editable grid. So somehow I need to do some sort of a check when a row =
contains a manual_id or key_id and is deleted, the row with the =
corresponding=20
id in keysets or manuals also has to be deleted. It's too bad that I =
can't use=20
the multiple table delete because I have version 3.23 and is only =
supported in=20
version 4.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Does anyone have an idea how to solve =
my=20
problem?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jeroen=20
Steggink</FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0029_01C2F58C.5DA583B0--
|
|
|
|
DonB
|
| Posted: 03/31/2003, 7:25 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0020_01C2F76F.E5604F80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
"Normally", this is handled by the DBMS as "cascading deletes (updates). =
I am not familiar with mySQL and so don't know if that is possible in =
that particular implementation.
From CCS, though, you can write a bit of custom event code (most likely =
in the before delete event), to do this using a series of separate=20
DELETEs (using SQL statements).
DonB
"Jeroen Steggink" <jeroen_steggink@hotmail.com> wrote in message =
news:b62mp4$8l3$1@news.codecharge.com...
I forgot to tell I'm using CCS 2, with PHP and MySQL.
"Jeroen Steggink" <jeroen_steggink@hotmail.com> wrote in message =
news:b62ko6$43d$1@news.codecharge.com...
Hi,
I have an editable grid and it updates/deletes values in one table. =
But when one or more rows are deleted, rows in another table need to be =
deleted too. The rows in the other tables (manuals, keysets) are =
represented by a manual_id and key_id in the table used with the =
editable grid. So somehow I need to do some sort of a check when a row =
contains a manual_id or key_id and is deleted, the row with the =
corresponding id in keysets or manuals also has to be deleted. It's too =
bad that I can't use the multiple table delete because I have version =
3.23 and is only supported in version 4.
Does anyone have an idea how to solve my problem?
Jeroen Steggink
------=_NextPart_000_0020_01C2F76F.E5604F80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>"Normally", this is handled by the DBMS =
as=20
"cascading deletes (updates). I am not familiar with mySQL and so =
don't=20
know if that is possible in that particular implementation.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>From CCS, though, you can write a bit =
of custom=20
event code (most likely in the before delete event), to do this using a =
series=20
of separate </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>DELETEs (using SQL =
statements).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>DonB</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeroen Steggink" <<A=20
=
href=3D"mailto:jeroen_steggink@hotmail.com">jeroen_steggink@hotmail.com</=
A>>=20
wrote in message <A=20
=
href=3D"news:b62mp4$8l3$1@news.codecharge.com">news:b62mp4$8l3$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I forgot to tell I'm using CCS 2, =
with PHP and=20
MySQL.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeroen Steggink" <<A=20
=
href=3D"mailto:jeroen_steggink@hotmail.com">jeroen_steggink@hotmail.com</=
A>>=20
wrote in message <A=20
=
href=3D"news:b62ko6$43d$1@news.codecharge.com">news:b62ko6$43d$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have an editable grid and it =
updates/deletes=20
values in one table. But when one or more rows are deleted, rows in =
another=20
table need to be deleted too. The rows in the other tables (manuals, =
keysets) are represented by a manual_id and key_id in the =
table=20
used with the editable grid. So somehow I need to do some sort of a =
check=20
when a row contains a manual_id or key_id and is deleted, the row =
with the=20
corresponding id in keysets or manuals also has to be deleted. It's =
too bad=20
that I can't use the multiple table delete because I have version =
3.23 and=20
is only supported in version 4.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Does anyone have an idea how to =
solve my=20
problem?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jeroen=20
Steggink</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0020_01C2F76F.E5604F80--
|
|
|
|
|
