mysql help

[gene02]

here is my code that doesn't work and I don't know why I'm sorta new at this.
<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>

[kylebuttress]

Hi,

Not real sure what scripting language you are programming in.

But the basic format for MySQL inserts is similar to the following

INSERT INTO `sometable` (`field_1`, `field_2`, `field_3`) VALUES ('val_1', 'val_2', 'val_3')

this format should work providing you have established a connection to the mysql database.

Hope this helps

regards

Kyle

[alpha5th]

I don't know much about ColdFusion, but maybe this will help?

http://livedocs.macromedia.com/coldf...nce/Tags78.htm

[Sashman]

The SQL inside the query tags are independent of the scripting language (cold fusion). Either read about mysql SQL or use cold fusion's CFINSERT or CFUPDATE functions. I particularily do not like using them, however they allow you to create code that works on pretty much any DB and don't really require an understanding of SQL.

[Nikolas]

You can also do that :

INSERT INTO `sometable` VALUES ('val_1', 'val_2', 'val_3')