Ok I got it now :) finally....
<cfquery name="commitVotes" datasource="packets">
INSERT INTO
packet_votes(date_voted,ipaddress,name,packet_id,reason,vote,voter_id)
(SELECT vote_attempted,ipaddress,name,packet_id,reason,vote,voter_id
FROM temp_votes
WHERE voter_id = #form.voterID#)
</cfquery>
Thanks for reading this though :)
Bob
> Hi folks,
>
> I'm trying to do something that seems like it should be relatively
> simple but have yet to get it right. In MySQL I have 2 tables,
> temp_votes and packet_votes. The temp_votes table holds all voting
> data until all packets have been voted on. I am trying to figure out
> the syntax for doing INSERT INTO SELECT but have yet to get it right.
> My last attempt looks like this:
>
> <cfquery name="commitVotes" datasource="packets">
> INSERT INTO packet_votes(date_voted,ipaddress,name,packet_id,reason,
> vote,voter_id)
> SELECT (vote_attempted,ipaddress,name,packet_id,reason,vote,voter_id)
> FROM temp_votes
> </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4532
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
