![]() |
Webmaster Forum Rules | Posting Guide | Contact Us | Testimonials | Contributing Geek Program | Advertise on Geek/Talk |
|
|
![]() |
|
Thread Tools | Display Modes |
![]() |
#1 |
Registered User
Join Date: Sep 2003
Location: Georgia
Posts: 4
|
![]()
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> |
![]() |
![]() |
![]() |
#2 |
Registered User
Join Date: Jan 2005
Location: Gold Coast - Australia
Posts: 27
|
![]()
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 |
![]() |
![]() |
![]() |
#3 |
Registered User
Join Date: Apr 2004
Location: Denmark
Posts: 6
|
![]()
I don't know much about ColdFusion, but maybe this will help?
http://livedocs.macromedia.com/coldf...nce/Tags78.htm |
![]() |
![]() |
![]() |
#4 |
Registered User
Join Date: Aug 2002
Location: Dulles Virginia
Posts: 590
|
![]()
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.
Last edited by Sashman; 01-30-2005 at 11:10 PM. |
![]() |
![]() |
![]() |
#5 | |
Registered User
Join Date: Feb 2005
Location: Greece
Posts: 62
|
![]()
You can also do that :
Quote:
|
|
![]() |
![]() |
![]() |
Bookmarks |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
MySQL installation problems. | b2gdotcom | Web Development - Programming / Coding | 3 | 11-29-2001 04:00 AM |
Uploading database (MySQL), and User Comments | masm50 | Web Development - Programming / Coding | 2 | 10-22-2001 03:45 AM |
Tip for heavy MySQL users: CREATE INDEX | demae | Web Hosting Discussion | 4 | 05-15-2001 04:32 PM |
vBullletin - Corrupted MySQL records! | Steve_S | Web Design and Webmaster Issues | 5 | 02-07-2001 12:44 AM |
mysql overload? | notibrian | Web Design and Webmaster Issues | 0 | 02-01-2001 09:03 PM |