hey guys, just a quick question.

im used to access queries, so im not sure what the deal is here. using mysql, v4.1 i beleive:
Code:
 Error Executing Database Query.
General error: Column count doesn't match value count at row 1
 
The error occurred in C:\Inetpub\wwwroot\cb\www\Manage\cfcs\ImportInventory.cfc: line 158
Called from C:\Inetpub\wwwroot\cb\www\Testing\ImportInventoryTest.cfm: line 9
Called from C:\Inetpub\wwwroot\cb\www\Manage\cfcs\ImportInventory.cfc: line 158
Called from C:\Inetpub\wwwroot\cb\www\Testing\ImportInventoryTest.cfm: line 9

156 : 						comp_ten --->)
157 : 						
158 : 						VALUES (#Variables.TempQuery.Item_num#

SQL 	   INSERT INTO Products (Item_num) VALUES ()
DATASOURCE 	  CBProducts
VENDORERRORCODE 	  1136
SQLSTATE 	  S1000
you can see there my sql statement, basically item_num doesnt have a value. so how would i put that in? its an int field, so it shouldnt have single quotes around it?

thanks for any help