Hi folks wondering if you can help with a little problem I
have. I'm trying to insert data into 4 tables and update the
related key using last0_insert_id() and set@ = last_insert_id();
When I run the query colfusion tells me I have a syntax
error.
2nd question is:
Can the insert query be written this way in coldfusion
or would it have to be broken down in to seperate queries.
The error occurred in
C:\CFusionMX7\wwwroot\review1\admin\insert1.cfm: line 34
32 :
33 : INSERT INTO review(user_id, accom_id, hotel, room, food,
entertainment, beach)
34 : VALUES(@user_id,
@Accom_id, '#Trim(FORM.hotel)#',
'#Trim(FORM.room)#',
'#Trim(FORM.food)#','#Trim(FORM.entertainment)#',
'#Trim(FORM.beach)#');
35 :
36 : </cfquery>
here is my query which looks ok syntax wise.
<cfquery datasource="reviews">
INSERT INTO country(country_name)
VALUES('#Trim(FORM.country_name)#');
set @country_id = last_insert_id();
INSERT INTO resort(country_id, resort_name)
VALUES(@country_id, '#Trim(FORM.resort_name)#');
set
@Resort_id = last_insert_id();
INSERT INTO accom(resort_id, accom_type_id, accom_name)
VALUES(@resort_id, #FORM.accom_type_id#,
'#Trim(FORM.accom_name)#');
set
@Accom_id = last_insert_id();
INSERT INTO users(first_name, last_name, email)
VALUES('#Trim(FORM.first_name)#', '#Trim(FORM.last_name)#',
'#Trim(FORM.email)#');
set
@user_id = last_insert_id();
INSERT INTO review(user_id, accom_id, hotel, room, food,
entertainment, beach)
VALUES(@user_id,
@Accom_id, '#Trim(FORM.hotel)#',
'#Trim(FORM.room)#',
'#Trim(FORM.food)#','#Trim(FORM.entertainment)#',
'#Trim(FORM.beach)#');
</cfquery>
8
Replies
AdChoices