Hey Wim, I already figured the std::endl error. But reminding me about the .str() was perfect, it solved everything else that was driving me crazy. The stringsstream >> string method Ive stumbled upon rather often while searching for how to use C++ stringstream, but its goddamn unreliable, so is also std::to_string(stringstream), especially when Im using special characters like / or * in the sentences.
Thanks for your input.
By the way, how would I be able to:
>> execute("SELECT * INTO OUTFILE = ? FIELDS TERMINATED BY ' ,'LINES TERMINATED
>> BY '\n' FROM sre_db.gsa_table and sre_db.gga_table WHERE job_number = ? and
>> point_number = ? ").bind(s).bind(jobnumber).bind(point number);
and use the ? variable to bind to a file name? is this even possible?
Regards,
Tor
7. mai 2014 kl. 15:16 skrev Wim Dumon <[email protected]>:
> Hi Tor,
>
> I don't think newlines are allowed in filenames, did you try without
> the std::endl?
> Also I usually use ss.str() to convert a stringstream to a string but
> I may simply be unaware of the >> method you're using.
>
> Wim.
>
>
> 2014-05-07 10:19 GMT+02:00 Tor Arne Fallingen <[email protected]>:
>> Hey guys,
>>
>> You probably have the answer to this for me. Im trying to dump selected data
>> from one or more tables into a file for export via email. I try this
>> sentence:
>>
>> execute("SELECT * INTO OUTFILE = ? FIELDS TERMINATED BY ' ,'LINES TERMINATED
>> BY '\n' FROM sre_db.gsa_table and sre_db.gga_table WHERE job_number = ? and
>> point_number = ? ").bind(s).bind(jobnumber).bind(point number);
>>
>>
>>
>> where I try to create the file name(s):
>>
>> std::stringstream ss;
>>
>> ss << "/Users/taf/downloads/Jobnumber_" << jobnumber << "_pointnumber_"
>> << pointnumber << ".csv" << std::endl;
>>
>> ss >> s;
>>
>>
>> based on the input of the method:
>>
>> void dbHandler::sqlQuery(int jobnumber, int pointnumber)
>>
>>
>>
>> The method doesn’t fail, but it doesn’t seem to create a file. Anyone have a
>> hint on what Im doing wrong here?
>>
>>
>> Regards,
>> Tor
>>
>> ------------------------------------------------------------------------------
>> Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
>> • 3 signs your SCM is hindering your productivity
>> • Requirements for releasing software faster
>> • Expert tips and advice for migrating your SCM now
>> http://p.sf.net/sfu/perforce
>> _______________________________________________
>> witty-interest mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/witty-interest
>>
>
> ------------------------------------------------------------------------------
> Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
> • 3 signs your SCM is hindering your productivity
> • Requirements for releasing software faster
> • Expert tips and advice for migrating your SCM now
> http://p.sf.net/sfu/perforce
> _______________________________________________
> witty-interest mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/witty-interest
signature.asc
Description: Message signed with OpenPGP using GPGMail
------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce
_______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
