Problem whith INSERT INTO

meinenr

Hi everybody,
I have a Problem whith the following line:
var myInsertQuery = "INSERT INTO test (id, customerId, amount)Values(trade.OtherSID, 0, 0)";

Unknown Column 'trade.OtherSID' in 'field list'

Somebody know how to fix it?

If I write:
PrintConsole("THE ID: " + trade.OtherSID + " .", ConsoleColor.Red);

it output the right ID, like:THE ID: STEAM_0:1:12345123 .

#CLOSED!!!

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitesh Kejriwal14y ago
Try this -

var myInsertQuery = "INSERT INTO test (id, customerId, amount)Values("+trade.OtherSID+", 0, 0)";
meinenr14y ago
#CLOSED!!!
Shivanand Arur14y ago
Have forwarded this link to few people.... Hope to get their replies soon...
Sorry for the inconvenience caused by me!!!
meinenr14y ago
Thank you...
Shivanand Arur14y ago
I'll forward this thread to some of my expert friends...
They will be able to help you out....
meinenr14y ago
Do you or someone else know, how i can use a Variable on INSERT INTO
Shivanand Arur14y ago
Hey meinenr I am trying to search a solution for the same issue on google but I am not able to get one.... I myself have never come across this kind of an issue, hence do not have much idea.... I am sorry.... May be someone else will help you out.... and you too search on google for the same type of issues...

Sorry once again!!!
meinenr14y ago
Now i use:
var myInsertQuery = "INSERT INTO test (id) Values ('trade.OtherSID')";

But now they only write trade.OtherSID as text in my line.

If i use:
var myInsertQuery = "INSERT INTO test (id) Values (trade.OtherSID)";

it said: Unknown solumn 'trade.OtherSID' in 'field list'
meinenr14y ago
The column name in my database is id.
Shivanand Arur14y ago
Hey recheck the column name in your table and also the Data type of that Column...
meinenr14y ago
If you know how you can Fix it, or you know it, if you cann see the full script, you can show me on Team Viewer too.
Shivanand Arur14y ago
Hey you can check out these links... May be they will help you solve the problem

http://www.techsupportforum.com/forums/f49/solved-php-mysql-unknown-column-in-field-list-374532.html

http://coding-talk.com/f14/mysql-error-unknown-column-in-field-list-11633/

http://stackoverflow.com/questions/1346209/unknown-column-in-field-list-error-on-mysql-update-query

http://www.codeproject.com/Questions/458833/Multiple-errors-in-MYSQL-database-problems-with-IN
meinenr14y ago
trade:
This is the User with whom I am in steam in trade
OtherSID:
This get the Steam ID from the User.
Shivanand Arur14y ago
Can you explain what does the "trade" object do??
Shivanand Arur14y ago
Hey can you post the entire query or the program where you have written this query... It might help us understand the issue in a better way!!!