sql syntax with arithmetic

I am getting a syntax error and I am not sure what I am doing wrong, any help would be much appreciated.

    INSERT INTO mashstp ( mid, name, time, temp, desc )
    VALUES ( '#mid#', '#mashstXML.mash_step.name.xm开发者_开发知识库ltext#',
    '( #mashstXML.mash_step.step_temp.xmltext# * 1.8 ) + 32 F',
    '#mashstXML.mash_step.description.xmltext#')        

---

You name 5 columns, but only pass 4 values.

mid     '#mid#'
name    '#mashstXML.mash_step.name.xmltext#'
time
temp    '( #mashstXML.mash_step.step_temp.xmltext# * 1.8 ) + 32 F'
desc    '#mashstXML.mash_step.description.xmltext#'

I think it's missing time.

---

It appears as if you've got your arithmetic inside the string you're inserting. Convert your text to a number and then do the math:

convert(float,'#mashstXML.mash_step.step_temp.xmltext#') * 1.8 + 32.0

---

You name five columns to receive values but only supply four values.