<div>
you have the '&quot; on either side of your where statement but not for each parameter.
</div>


you have the '" on either side of your where statement but not for each parameter.

<div>
<div class="content wysiwyg-content">
I can not for the life of me see an error in this sql statement<br />
<br />
insertprinterm = &quot;insert into printer_maintanence (photoconductor, cartridge_yellow, cartridge_cyan, cartridge_magenta, cartridge_black, maintanence_kit, transfer_belt, wastebox, duplexer) &nbsp;values(&quot; &amp;&nbsp;photo &amp;&nbsp;&quot;,&quot; &amp;&nbsp;yellow &amp;&nbsp;&quot;,&quot; &amp;&nbsp;cyan &amp;&nbsp;&quot;,&quot; &amp;&nbsp;magenta &amp;&nbsp;&quot;,&quot; &amp;&nbsp;black &amp;&nbsp;&quot;,&quot; &amp;&nbsp;maint &amp;&nbsp;&quot;,&quot; &amp;&nbsp;transfer &amp;&nbsp;&quot;,&quot; &amp;&nbsp;waste &amp;&nbsp;&quot;,&quot; &amp;&nbsp;duplexor &amp;&nbsp;&quot;) &nbsp;where whatip = '&quot; &amp;&nbsp;thisip &amp;&nbsp;&quot;' AND whatdate = '&quot; &amp;&nbsp;thisdate &amp;&nbsp;&quot;' &nbsp;&quot;<br />
<br />
thanks<br />
gary
</div>
</div>


I can not for the life of me see an error in this sql statement

insertprinterm = "insert into printer_maintanence (photoconductor, cartridge_yellow, cartridge_cyan, cartridge_magenta, cartridge_black, maintanence_kit, transfer_belt, wastebox, duplexer)  values(" & photo & "," & yellow & "," & cyan & "," & magenta & "," & black & "," & maint & "," & transfer & "," & waste & "," & duplexor & ")  where whatip = '" & thisip & "' AND whatdate = '" & thisdate & "'  "

thanks
gary

MESSAGE error near where

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.