RE: Newline inserted?


Matthew Dougerty [mailto:mdougher@xxxxxxxx] wrote:
>
> I'm assuming that those characters are part of the text. I assume the
> last
> text field is:
> 'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;'
>
> This way the SQL statement ends like:
> 'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')
>
> The interpreter doesn't know which ') to stop at.

No, the last field is 'H4vgmf+OJsT99kCfQuIpALY7k9k='. The final single
quote is part of the error message.

DBD::Oracle::st execute failed: ORA-00911: invalid character (DBD ERROR:
error possibly near <*> indicator at char 238 in 'INSERT INTO
message(FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE,SHA1)
VALUES('2005-Oct-18
11:53:21','pkitest.wellsfargo.com','auth','info','su(pam_unix)[3638]:
session opened for user oracle by
root(uid=0)','H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')


Ronald

.

Relevant Pages

  • Update Access Memo field from ASP.NET
    ... I'm having difficulty with trying to update a Access memo field through an ... SQL statement where the value I'm trying to pass is longer than 255 ... characters. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Set a field to NULL
    ... > How do I set a field = NULL in an SQL statement? ... > single quotes with no characters -) I get a foreign key constraint error ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Wrong Weeknumber
    ... It works with numbers instead of constantnames. ... It was taken from some other place where the SQL statement is ... Ronald ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Using Like operator in VBA
    ... a left bracket [inside the bracket pair to test whether the string ... text string in a SQL statement that you would want to test for? ... If YourVariable contains any of the wildcard characters that are used ...
    (microsoft.public.access.modulesdaovba)
  • Re: Viewing the contents of two tables using ASP and MS Access
    ... Number of fields in a recordset 255 ... Number of characters in a cell in the query design grid 1,024 ... Number of characters in an SQL statement approximately 64,000 ...
    (microsoft.public.inetserver.asp.db)