That surely was it, thank you. Jerry Johnson <[EMAIL PROTECTED]> wrote: In an insert statement, you don't need the "tml_list =" in the values set.
INSERT into tbl (field_list) VALUES (valuelist) so in your example INSERT INTO List_prac (tbl_list) VALUES () On 4/14/06, john holmes wrote: > Hi, > I have an list that I need to insert into a mysql database and I am not quite > sure how to do it. Right now I take the list variable "#thiswillbemylist#" > and if I run a cfloop list to insert it but it just gets a null value in > database. > > The part of query to insert is this: > > > > INSERT INTO List_prac (tbl_list) > VALUES (tbl_list = ) > > > > > Can someone help? > Thanks > John > > > > --------------------------------- > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates > starting at 1�/min. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
