Dear Gabor,

Thanks for your help. I was trying to do what you ask me and I've found the
solution.

> with(teste,sprintf("INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES
(%s, %5.2f, %5.2f, %5.2f,%s)",date2,T_2M,TMAX_2M,TMIN_2M,Station_NO))
Error in sprintf("INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (%s,
%5.2f, %5.2f, %5.2f,%s)",  :
  invalid format '%5.2f'; use format %s for character objects
>
>
> with(teste,sprintf("INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES
(%s, %s, %s, %s,%s)",date2,T_2M,TMAX_2M,TMIN_2M,Station_NO))

 [1] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 22.5,
NULL, 22.4,820420)"
 [2] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 26.9,
NULL, 23.4,820980)"
 [3] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 24.3,
NULL, 23.3,821130)"
 [4] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 24.4,
NULL, 23.7,821410)"
 [5] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 28.2,
NULL, 21.1,821450)"
 [6] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 23.3,
NULL, 22.8,821810)"


On Mon, May 9, 2011 at 2:05 PM, Gabor Grothendieck
<ggrothendieck@gmail.com>wrote:

>  On Mon, May 9, 2011 at 12:59 PM, Nilza BARROS <nilzabarros@gmail.com>
> wrote:
> > Hi, Thanks for your attentio.
> >
> > I have the data frame below:
> > ====
> >> head(Alldados)
> >   Station_NO       date1 T_2M TMAX_2M TMIN_2M TD_2M     PS FF_10M DD_10M
> > 1     820420 110429/1200 22.5    NULL    22.4  22.2   NULL      0      0
> > 2     820980 110429/1200 26.9    NULL    23.4  24.1 1010.2   2.91    360
> > 3     821130 110429/1200 24.3    NULL    23.3  23.7   NULL   1.94    230
> > 4     821410 110429/1200 24.4    NULL    23.7  24.2 1011.8   2.91    270
> > 5     821450 110429/1200 28.2    NULL    21.1  25.8 1008.8      0      0
> > 6     821810 110429/1200 23.3    NULL    22.8  22.9 1001.6      0      0
> >   TOT_PRCP CLCL      date2
> > 1    84.00 NULL 2011042912
> > 2     2.00 NULL 2011042912
> > 3     3.00 NULL 2011042912
> > 4    12.00 NULL 2011042912
> > 5     6.00 NULL 2011042912
> > 6    38.00 NULL 2011042912
> > ====
> > Now each line will feed my database. So I need to format each line like
> > below:
> >
> > ===================================
> >  [1] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 22.50,    NA, 22.40,22.20,   NA, 0.00, 0.00,36.00,
> > NA,820420)"
> >   [2] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 26.90,    NA, 23.40,24.10,1010.20, 2.91,360.00,16.00,
> > NA,820980)"
> >   [3] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 24.30,    NA, 23.30,23.70,   NA, 1.94,230.00,19.00,
> > NA,821130)"
> >   [4] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 24.40,    NA, 23.70,24.20,1011.80, 2.91,270.00,12.00,
> > NA,821410)"
> >   [5] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 28.20,    NA, 21.10,25.80,1008.80, 0.00, 0.00,31.00,
> > NA,821450)"
> >   [6] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 23.30,    NA, 22.80,22.90,1001.60, 0.00, 0.00,24.00,
> > NA,821810)"
> >   [7] "INSERT INTO OBS
> > ===============
> >
>
> Please
>
> 1. reduce Allados to a smaller number of columns and rows.  Say 10
> rows and 3 columns such that it still exhibits the problem and then
> show the result of dput:
>
> dput(smallDF)
>
> 2. provide the R code that you would use with smallDF
>
> 3. explain what the problem is and how that differs from what you expect.
>
> --
>  Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>



-- 
Abraço,
Nilza Barros

	[[alternative HTML version deleted]]

