I find that the sprintf function is quite accurate and very fast.
>Yea, that's about what I've come up with myself, but I thought I'd ask.
>
>I have found that the strstream class works very nicely for building queries
>though. If you're willing to use C++ of course.
>Thanks
>
>-----Original Message-----
>From: Will French [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, September 25, 2001 1:12 PM
>To: George Eric R Contr AFSPC/CVYZ; [EMAIL PROTECTED]
>Subject: RE: Inserting Numeric Data with the C API
>
>
>I searched pretty thoroughly for a way to access mysql data in their native
>field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and
>came up with nothing. If you are processing large amounts of data you may
>want to do what I did which was to make my program build a load file (and
>then load it, of course). I found this method had performance advantages.
>
>
> > -----Original Message-----
> > From: George Eric R Contr AFSPC/CVYZ
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 25, 2001 3:00 PM
> > To: [EMAIL PROTECTED]
> > Subject: Inserting Numeric Data with the C API
> >
> >
> > Hi,
> > Is there anyway to do this other then copying a representation of the data
> > into the query string?
> > This just seems pretty inneffiecient (making an extra copy of the data) &
> > error prone (getting the representation right when you copy it to the
> > string).
> > Thanks
> > Eric
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-8249
Email [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
