marc
|
| Posted: 05/15/2002, 6:37 AM |
|
I need to execute a sql statement after update (events)
The sql: INSERT INTO mail ( member_id )
SELECT vakantiedagen.Membervakantie_ID
FROM vakantiedagen;
Can anyone helps me with the exact instruction?
Thanks in advance
|
|
|
 |
Nicole
|
| Posted: 05/15/2002, 7:32 AM |
|
Marc,
please provide your programming language. Also do you use CC or CC Studio?
|
|
|
|
marc
|
| Posted: 05/15/2002, 8:18 AM |
|
 thanks for the quick response. I'm using CC and ASP
|
|
|
|
Nicole
|
| Posted: 05/16/2002, 1:23 AM |
|
Marc,
try to use following code to execute sql query:
cn.execute(INSERT INTO mail ( member_id ) SELECT vakantiedagen.Membervakantie_ID
FROM vakantiedagen)
|
|
|
|
marc
|
| Posted: 05/20/2002, 11:57 AM |
|
I receive the message:
Compilatiefout Microsoft VBScript fout '800a03ee'
')' expected
/portal2/AdminvakantiedagenRecord.asp, regel 466
cn.execute(INSERT INTO mail SELECT vakantiedagen.Membervakantie_ID, vakantiedagen.Hele_dag FROM vakantiedagen)
How is that possible?
Thanks in advance
|
|
|
|
Nicole
|
| Posted: 05/21/2002, 1:57 AM |
|
Marc,
Oh,..I'm really sorry!
try this one:
cn.execute("INSERT INTO mail ( member_id ) SELECT vakantiedagen.Membervakantie_ID
FROM vakantiedagen")
|
|
|
|
marc
|
| Posted: 05/21/2002, 9:38 AM |
|
Nicole, IT WORKS !!!
One final question:
How can I join the Nicole Fanclub???
Marc
|
|
|
|
Nicole
|
| Posted: 05/22/2002, 12:26 AM |
|
Marc,
just post your questions here, on discussion board :)
|
|
|
|
Humberto Ahumada
|
| Posted: 01/16/2003, 3:17 PM |
|
How can I implement something similar on PHP and MySQL using CC 2.05?
This is my query I am trying to run:
delete from tLastLead;
insert into tLastLead
(tLeadID,THistoryID)
select hLeadID,
max(hHistoryID) from historial
group by 1;
|
|
|
|
