SQL INSERT

[jonnyshaw]

im very confused with my sql statement, Can anyone see anything wrong with it??

<CFQUERY datasource="#Application.datasource#" name="AddCartItem">

INSERT INTO tblCartItems (CartIDPK, ItemIDPK, Quantity, Colour, Size)
VALUES ('#Session.CartID#','#Form.ItemID#','1','#Form.Colour#,'#Form.Size#')
</cfquery>

Thanks For Any Help

 

[PHV]

At least, unbalanced single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jonnyshaw]

what do you mean by that

 

[PHV]

...,'#Form.Colour#[!]'[/!],'#...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jonnyshaw]

i have changed that but it still comes up with syntax error

 

[JarlH]

SIZE is a reserved word in ANSI/ISO SQL.

You'll have to delimit that column name (i.e. "Size".)

 

[r937]

the ID columns as well as Quantity are probably numeric, in which case you should not be trying to insert strings into them -- remove the quotes

r937.com | rudy.ca