primitiveType
New Member
First off, I apologize if i'm posting in the wrong place. I looked around and this seemed like the right place.
I have started using the SQL plugin for 1.5, and I am very satisfied with it. However, I have noticed some unusual behavior that is keeping me from accomplishing what I need to with it.
I have two different queries running in the same form. When I use just one, the problem does not occur. WHen I use them both, they appear to each be double posting... Here are the queries.
INSERT INTO tablename
( lname, about, location , website, email, comment, date, status, companyname, fname)
SELECT LastName, ' ' , ' ', ' ', ' ', ' ', ' ', 2 , CompanyName, FirstName
FROM table2
WHERE status LIKE 'ALLOW' ;
and
UPDATE table2
SET status='MIGRATED'
WHERE status LIKE 'ALLOW';
in that order. What is happening is that the rows that are meant to be copied into the other table are being copied twice before the status field is changed. These two queries are in seperate elements on the same form.
Any help is greatly appreciated.
I have started using the SQL plugin for 1.5, and I am very satisfied with it. However, I have noticed some unusual behavior that is keeping me from accomplishing what I need to with it.
I have two different queries running in the same form. When I use just one, the problem does not occur. WHen I use them both, they appear to each be double posting... Here are the queries.
INSERT INTO tablename
( lname, about, location , website, email, comment, date, status, companyname, fname)
SELECT LastName, ' ' , ' ', ' ', ' ', ' ', ' ', 2 , CompanyName, FirstName
FROM table2
WHERE status LIKE 'ALLOW' ;
and
UPDATE table2
SET status='MIGRATED'
WHERE status LIKE 'ALLOW';
in that order. What is happening is that the rows that are meant to be copied into the other table are being copied twice before the status field is changed. These two queries are in seperate elements on the same form.
Any help is greatly appreciated.