Database Syntax

[gregarion]

Hey guys I want to insert values into a MySql database. The following line works fine:

mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')");

but if the data to be inserted is from a string... like....

string NewTitle = "Monaco";
string NumofShows = "2";

What can i do so it will be able to read the strings and use their values to be inserted into the data table?

[ThatsAlok]

CString.Format can help in this!

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers, Alok Gupta VC Forum Q&A :- I/IV Support CRY- Child Relief and You

[Game point]

try char* NewTitle = "Monaco"; char* NumofShows = "2";

:~ Failure is Success If we learn from it!!:~

[gregarion]

Could you explain how i can insert it into my sql query to show how it works?

[gregarion]

Sorry, i do not get u? i mean, how do we insert the variables "NewTitle" and "NumofShows" into the sql statement so it can read the varaibles..

[Game point]

mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')")

char* NewTitle = "Monaco"; char* NumofShows = "2"; CString InsertQuery= "INSERT INTO main (" + (CString)NumofShows +","+(CString) NewTitle +") VALUES('12', 'Home')"; mysql_query(connection,InsertQuery); before that change your project properties unicode into multibyte ..i hope this ll work ..if any error comes send it !!!

:~ Failure is Success If we learn from it!!:~

[gregarion]

mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')")

Sorry i think you misunderstood what i meant. Normally, for the values, it has to be hardcoded in, for example, having to put 12 and home inside. What i meant is, for example, if the values to be inserted are in a variable , like .. string NewShowName = "Danger" int NewNumberofShow = "2" How do i put in this variables (NewShowName, NewNumberofShow) into the sql statements at VALUES so the program can read the values inside this variables and then save them in the database

[Lost User]

Might I suggest you will probably get a better response in the Database forum for this question.

MVP 2010 - are they mad?

[David Crow]

If you are using MFC, try:

CString strQuery;
strQuery.Format("INSERT INTO main (NumofShows , Title) VALUES('%d', '%s')", number, title);

If not, you can use the same format with sprintf();

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Man who follows car will be exhausted." - Confucius

[Maximilien]

Why did you removed your message ? Other people cannot learn from your experience because they do not know the question.

This signature was proudly tested on animals.

[gregarion]

What is MFC and what does "%d" and "%s" stands for?

[David Crow]

gregarion wrote:

What is MFC...

See here and here.

gregarion wrote:

...what does "%d" and "%s" stands for?

See here.

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Man who follows car will be exhausted." - Confucius

[gregarion]

Im using netbeans. i dont think there are such libraries

[David Crow]

gregarion wrote:

Im using netbeans.

So do you have a C or C++ question?

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Man who follows car will be exhausted." - Confucius

[gregarion]

C++

[Maximilien]

I sense a big failure soon.

This signature was proudly tested on animals.

[ThatsAlok]

_sprintf will solve your problem then

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers, Alok Gupta VC Forum Q&A :- I/IV Support CRY- Child Relief and You