7 messages in com.mysql.lists.plusplusinteresting problem| From | Sent On | Attachments |
|---|---|---|
| JD Smith | 23 Mar 2004 20:06 | |
| Sinisa Milivojevic | 24 Mar 2004 04:07 | |
| Jae Joo | 24 Mar 2004 07:26 | |
| JD Smith | 24 Mar 2004 07:37 | |
| JD Smith | 24 Mar 2004 07:46 | |
| Sinisa Milivojevic | 25 Mar 2004 03:40 | |
| Sinisa Milivojevic | 25 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




