Tor,
That should work (the binding part), but I don't know if the query is
correct, I've never used 'into outfile'.
BR,
Wim.
2014-05-07 15:34 GMT+02:00 Tor Arne Fallingen <fallin...@gmail.com>:
> 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 <w...@emweb.be>:
>
>> 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 <fallin...@gmail.com>:
>>> 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
>>> witty-interest@lists.sourceforge.net
>>> 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
>> witty-interest@lists.sourceforge.net
>> 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
> witty-interest@lists.sourceforge.net
> 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
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest
