Limit 255 char

[webfox]

Hello!
I have a Visual FoxPro table with Memos fields, and when i insert into the
table a value that cames from a TEXTAREA field on a form, give me an error.
Why? if the table field is MEMO?
Thanks

[Manohar Kamath [MVP]]

Could you please show us the error message?

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"webfox" <webfox@sapo.pt> wrote in message
news:%23Zk4iBLcDHA.3044@TK2MSFTNGP11.phx.gbl...

> Hello!
> I have a Visual FoxPro table with Memos fields, and when i insert into the
> table a value that cames from a TEXTAREA field on a form, give me an

error.

> Why? if the table field is MEMO?
> Thanks
>
>

[webfox]

The erro give me this:

a.. Tipo de erro:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized
phrase/keyword.
/gqweb/gqregproc2.asp, linha 55

*Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET
CLR 1.0.3705)


a.. Page:
POST 641 bytes para /gqweb/gqregproc2.asp?fazer=inserir

a.. Dados POST
ftipo=N&fdataprev=5&freceptor=gqmonitor@ruitrol.ne t&fcausas=N%E3o+aplic%E1ve
l.&ftexto=++123456789+123456789+123456789+12345678 9+123456789+123456789+1234
56789+123456789+123456789+123456789+123456789+12 . . .


The line 55 have :

Set rsREGI = Server.CreateObject("ADODB.Recordset")
SQLREGI ="INSERT INTO registos
(processo,etapa,tipo,emissor,bcc,receptor,cc,data, assunto,texto,sit,ficheiro
,id_ref,refproant,obs,id_refocor,sector,importante ,id_forn,via,docref,datapr
ev,respacc,alerta,devol,causas,reqnorma) VALUES
("&fprocesso&","&fetapa&",'"&Request.Form("ftipo") &"','"&futilizador&"','"&f
bcc&"','"&Request.Form("freceptor")&"','"&Request. Form("fcc")&"',date(),'"&f
assunto&"','"&fTexto&"','A','"&xpathficheiro&"','' ,'','"&fObs&"','','"&fsect
or&"',.f.,0,'Mail','',ctod('"&fdias&"'),'',ctod(' . . '),ctod(' . .
'),'" & Request.form("fcausas") & "','"&freqnorma&"')"
rsREGI.Open SQLREGI,ConnF,0,3





"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> escreveu na mensagem
news:OUKdTnQcDHA.1044@TK2MSFTNGP10.phx.gbl...

> Could you please show us the error message?
>
> --
> Manohar Kamath
> Editor, .netBooks
> [url]www.dotnetbooks.com[/url]
>
>
> "webfox" <webfox@sapo.pt> wrote in message
> news:%23Zk4iBLcDHA.3044@TK2MSFTNGP11.phx.gbl...

> > Hello!
> > I have a Visual FoxPro table with Memos fields, and when i insert into

the

> > table a value that cames from a TEXTAREA field on a form, give me an

> error.

> > Why? if the table field is MEMO?
> > Thanks
> >
> >

>
>

[Karim Dahdah]

Maybe because you forget to double-quote the strings?

replace(Request.Form("freceptor"),"'","''")

Best regards,

Karim Dahdah
[url]www.doran.be[/url]




"webfox" <webfox@sapo.pt> wrote in message
news:e4MN2IgcDHA.2904@TK2MSFTNGP11.phx.gbl...

> The erro give me this:
>
> a.. Tipo de erro:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized
> phrase/keyword.
> /gqweb/gqregproc2.asp, linha 55
>
> *Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET
> CLR 1.0.3705)
>
>
> a.. Page:
> POST 641 bytes para /gqweb/gqregproc2.asp?fazer=inserir
>
> a.. Dados POST
>

ftipo=N&fdataprev=5&freceptor=gqmonitor@ruitrol.ne t&fcausas=N%E3o+aplic%E1ve

>

l.&ftexto=++123456789+123456789+123456789+12345678 9+123456789+123456789+1234

> 56789+123456789+123456789+123456789+123456789+12 . . .
>
>
> The line 55 have :
>
> Set rsREGI = Server.CreateObject("ADODB.Recordset")
> SQLREGI ="INSERT INTO registos
>

(processo,etapa,tipo,emissor,bcc,receptor,cc,data, assunto,texto,sit,ficheiro

>

,id_ref,refproant,obs,id_refocor,sector,importante ,id_forn,via,docref,datapr

> ev,respacc,alerta,devol,causas,reqnorma) VALUES
>

("&fprocesso&","&fetapa&",'"&Request.Form("ftipo") &"','"&futilizador&"','"&f

>

bcc&"','"&Request.Form("freceptor")&"','"&Request. Form("fcc")&"',date(),'"&f

>

assunto&"','"&fTexto&"','A','"&xpathficheiro&"','' ,'','"&fObs&"','','"&fsect

> or&"',.f.,0,'Mail','',ctod('"&fdias&"'),'',ctod(' . . '),ctod(' .

..

> '),'" & Request.form("fcausas") & "','"&freqnorma&"')"
> rsREGI.Open SQLREGI,ConnF,0,3
>
>
>
>
>
> "Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> escreveu na

mensagem

> news:OUKdTnQcDHA.1044@TK2MSFTNGP10.phx.gbl...

> > Could you please show us the error message?
> >
> > --
> > Manohar Kamath
> > Editor, .netBooks
> > [url]www.dotnetbooks.com[/url]
> >
> >
> > "webfox" <webfox@sapo.pt> wrote in message
> > news:%23Zk4iBLcDHA.3044@TK2MSFTNGP11.phx.gbl...

> > > Hello!
> > > I have a Visual FoxPro table with Memos fields, and when i insert into

> the

> > > table a value that cames from a TEXTAREA field on a form, give me an

> > error.

> > > Why? if the table field is MEMO?
> > > Thanks
> > >
> > >

> >
> >

>
>