7 messages in com.mysql.lists.plusplusinteresting problem
FromSent OnAttachments
JD Smith23 Mar 2004 20:06 
Sinisa Milivojevic24 Mar 2004 04:07 
Jae Joo24 Mar 2004 07:26 
JD Smith24 Mar 2004 07:37 
JD Smith24 Mar 2004 07:46 
Sinisa Milivojevic25 Mar 2004 03:40 
Sinisa Milivojevic25 Mar 2004 03:42 
Subject:interesting problem
From:JD Smith (jdsm@letu.edu)
Date:03/23/2004 08:06:42 PM
List:com.mysql.lists.plusplus

Well, I finally got everything working again so I went to start making
modifications for the next stage of implementation of my project. Below is an
example pulled from one of a few functions that use similar constructs:

query << "UPDATE material SET ar_unit = '" << argument << "' WHERE type = '" <<
ch->desc->edit_string << "'"; query.execute();

query << "SELECT @tempcat:=category FROM material_categories WHERE
category_standard = '" << ch->desc->edit_string << "'"; query.execute();

query << "UPDATE material SET ar_unit = '" << argument << " * ar_pct / 100'
WHERE category = @tempcat"; query.execute();

It /always/ crashes on the third query even if I were to make it the same as the
first query.. This is making absolutely no sense. I have verified the data is
correct in the table and I typed all of my query code into the mysql terminal to
verify that it is correct. Guess what? It returns the expected values. Anyone
have any ideas?

- JD