Inserting Updating data...?

2000-06-30 Thread Patric Stumpe

Hello all you coders,

i have the following problem:

a customer shall make an entry to a database where the entered data gets to
table A. This is surely simple and already works fine :). Now I try to
update a record in another table B (where the customers infos are stored).
There is a field containing a list of id's (foreign key?!) belonging to the
entries he already entered.

So how can I update the customers record (the field 'list_entries') in table
B while inserting the entry he made to table A. I really don't know how to
get the data to that list...

many thanks in advance

Patric Stumpe


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Inserting Updating data...?

2000-06-30 Thread Mark Warrick

I believe you would just run two queries at the same time.

Or am I missing something here?

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 30, 2000 11:03 AM
 To: cf-talk
 Subject: Inserting  Updating data...?
 
 
 Hello all you coders,
 
 i have the following problem:
 
 a customer shall make an entry to a database where the entered 
 data gets to
 table A. This is surely simple and already works fine :). Now I try to
 update a record in another table B (where the customers infos are stored).
 There is a field containing a list of id's (foreign key?!) 
 belonging to the
 entries he already entered.
 
 So how can I update the customers record (the field 
 'list_entries') in table
 B while inserting the entry he made to table A. I really don't know how to
 get the data to that list...
 
 many thanks in advance
 
 Patric Stumpe
 
 
 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.