Ask a Question related to Coldfusion Database Access, Design and Development.
-
jawwinker #1
CFINSERT into multiple tables? MySQL
Hello,
I'm working on a project where I need to insert form data into two tables on
my MySQL database, and I'm having difficulty getting the results I want. I
read in the WACK manual, that CFINSERT works for only one table. Has anyone
figured out a workaround for this? The WACK manual said that SQL INSERT can
perform this operation, but my reference doesn't mention anything about it. If
anyone has any insight it is greatly appreciated.
Thanks!
Steve
jawwinker Guest
-
Update multiple tables
Hi, Default MX Update Record Server Behaviour only lets you change one table in the database - I need to update two or more, i.e. Address table,... -
Delete against multiple tables + And / Or
Hi there, a part of my music site exists of three tables: songs -> id, artist_id, song_name lyrics -> id, song_id, lyrics genre -> id,... -
update multiple records in multiple tables from one form
hello I have been trying to run multiple update queries based on the data entered by user. Brief background: I am fetching data from various... -
MySQL Multiple tables / results
Hopefully someone here can help. I would like to perform multiple queries to a MySQL database and have all the results in 1 result set. Is this... -
Multiple MySQL tables
Hello! I need some help with tables in MySQL. I am making a colums of articles in my site. It has 3 posters that post articles. I make a little... -
Dan Bracuk #2 Re: CFINSERT into multiple tables? MySQL
Use two cfquery tags instead. The first two words of each query will be "insert into"
Dan Bracuk Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
