insert a list into database

[john holmes]

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:

<cfloop list="#thiswillbemylist#" index="i">
    <cfquery name="listinsert" datasource="#rdatasource#" username="#username#" 
password="#password#">
        INSERT INTO        List_prac (tbl_list)
        VALUES             (tbl_list = <cfqueryparam value="#i#" 
cfsqltype="cf_sql_varchar">)
    </cfquery>
 </cfloop>


Can someone help?
Thanks
John


                
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates 
starting at 1&cent;/min.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237729
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