Got it working, had to make my own inserting script, and not use cfinsert.
if anyone wants to see the code, tho i am sure someone has a more efficient
one, (if so please let me know);
<!--- insert the values --->
<cfset count = 1>
<cfquery
datasource="#request.dbname#"
username="#request.dbuser#"
password="#request.dbpass#">
INSERT INTO sites (#StructKeyList(formPacket)#)
VALUES (
<cfloop list="#StructKeyList(formPacket)#" index="i">
"#StructFind(formPacket, i)#"
<cfif count NEQ ListLen(StructKeyList(formPacket))>
,
</cfif>
<cfset count = incrementvalue(count)>
</cfloop>
)
</cfquery>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
