List:MySQL++« Previous MessageNext Message »
From:Jay Sprenkle Date:July 13 2011 9:40pm
Subject:Re: update fails... any suggestions?
View as plain text  
My catch blocks weren't correct.

It looks like an escaping error on the blob.

Thanks for the help.

On Wed, Jul 13, 2011 at 4:18 PM, Warren Young <mysqlpp@stripped> wrote:

> On 7/13/2011 2:58 PM, Jay Sprenkle wrote:
>
>>
>> The revised query still seg faults when exceptions are turned on.
>>
>
> It's probably due to an uncaught exception.
>
> If you replace the execute() call with preview() instead and send what it
> returns to cout or similar, you will probably find that the resulting query
> isn't syntactically correct, so the exception is probably BadQuery.
>
>
>  I tried quoting just the password, and again quoting all the parameters
>> (using the 'q').
>>
>
> Looking at the code, it looks like that *should* quote and escape a BLOB.
>  Do the preview() check to find out.
>
> Or, again, use SSQLS, which handles this for you.  See
> examples/load_jpeg.cpp.  Notice that there is no futzing around with quoting
> and escaping.
>
>
>  Is the escaping mechanism intended for text perhaps?
>>
>
> SQL *is* text.  You can't insert random binary data into a SQL query string
> without escaping it.
>
>

Thread
update fails... any suggestions?Jay Sprenkle13 Jul
  • Re: update fails... any suggestions?Warren Young13 Jul
    • Re: update fails... any suggestions?Jay Sprenkle13 Jul
      • Re: update fails... any suggestions?Warren Young13 Jul
        • Re: update fails... any suggestions?Warren Young13 Jul
        • Re: update fails... any suggestions?Jay Sprenkle13 Jul
          • Re: update fails... any suggestions?Kemet14 Jul
            • Re: update fails... any suggestions?Warren Young14 Jul
              • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                  • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                    • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                      • Re: update fails... any suggestions?Warren Young15 Jul
                        • Re: update fails... any suggestions?Jay Sprenkle15 Jul