MYSQL code needs help

[gene02]

I am using cold fussion and I have something wrong with my query here and don't know what it is if you can see it please help
<cfquery name="dpost" datasource="tankerloads">
INSERT INTO `Customers`
(`customer_ID`, `customer_name`, `customer_address`, `customer_city`, `customer_state`, `contact_number`, `contact_email`)
</cfquery>
<cfquery name="dpost" datasource="tankerloads">
INSERT INTO `destination`
(`dest_city` ,
`dest_state` ,
`del_date` ,
`customer_city`)
</cfquery>

[rivux]

Well you are missing half of your insert query, you need the Values clause in there, so the db knows what to insert.

<cfquery name="dpost" datasource="tankerloads">
INSERT INTO `Customers`
(`customer_ID`, `customer_name`, `customer_address`, `customer_city`, `customer_state`, `contact_number`, `contact_email`)
VALUES (12, "Jim Bob", "123 Here", "Mycity", "Ohio", "555-555-1234", "jim@bob.com")
</cfquery>

[gene02]

thanks for your help as always when I post a problem here I get a responce.