Create a comma seprated string from SQL result

Question

1.00/5 (1 vote)

See more:

I have a data like this

SQL

 ID         ITEM NO
45824587	  2545654
32589662      5878985
11414252      2145477
25789632      2458926

I want to allocate a char pointer and want to store the result using comma like

char *ptr = 45824587,32589662,11414252,25789632;2545654,5878985,2145477,2458926

Please provide me with the code

Posted 17-Aug-15 6:17am

Tarun22

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-08-17T06:24:00

Solution 1

It doesn't quite work like that.
We do not do your work for you.
If you want someone to write your code, you have to pay - I suggest you go to Freelancer.com and ask there.

But be aware: you get what you pay for. Pay peanuts, get monkeys.

Posted 17-Aug-15 6:24am

OriginalGriff

CPallini · Answer 2 · 2015-08-17T06:36:00

Solution 2

Using C++ would make your life easier.
If you have to use C then you must allocate (either statically or dynamically) a big enough buffer (character array) for holding your comma-separated values. Then you have to build the comma-separated values using the fetched result (without knowing how are you actually going to fetch the database results, we cannot help more).

Posted 17-Aug-15 6:36am

CPallini

Comments

Tarun22 17-Aug-15 12:46pm

sir i am running query in c like this mysql_query(con, "Select * from table where client_type = 1")
I just want to store the result in char array as shown above

CPallini 17-Aug-15 12:52pm

You know, you have to perform additional steps in order to actually retrieve the results, see, for instance, this tutorial:
http://zetcode.com/db/mysqlc/
Check out the "Retrieving data from the database" section.

Tarun22 17-Aug-15 12:57pm

i have to run this query (field = mysql_fetch_field(result)) but i want to get the result comma separated in char array

CPallini 17-Aug-15 13:08pm

According to the documentation, mysql_fetch_field "Returns the definition of one column of a result set" not the actual data.
You must first be able to actually collect the data and then arrange them using given format.

Tarun22 17-Aug-15 13:32pm

Thats true suppose first time it has value 123456 then 656563 how do i insert ";" in between.Can i have pseudo code for that?

Ujesh Mohanan · Answer 3 · 2015-08-17T08:44:00

Solution 3

In C, you may use 'sprintf' inside a loop. You first need to allocate a character array(say ptr) of enough size and initialize it with the value of the first record. Then inside a loop do the following,

C++

sprintf(ptr, "%s, %s", ptr, nextValue);

Posted 17-Aug-15 8:44am

Ujesh Mohanan