RE: Need Help: Cursor operation conflict with Prepared UPDATE sta tement

Thanks for the extra pair of eyes.  That was indeed most of the
problem.

Thanks,
-Jeff

--- "Zabach, Elke" <[email protected]> wrote:
> J. Jeff Roberts wrote
> 
> > 
> > I'm trying to create a prepared statement for the following update:
> > 
> >   UPDATE jobhistory SET status=6 WHERE id = '3D1065E0_00001000'
> > 
> > The SQL I send to SQLPrepare() looks like this:
> > 
> >   UPDATE jobhistory SET status=? WHERE id = '?'
> 
> ? do mean a placeholder for a variable, right?
> But why do you surround the second placeholder with ' ' ?
> Then the database server will not see the placeholder, but a string
> with
> exactly one question-mark in


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com