Re: Wrong sintax...? GOT IT!

From: Frank Hickman (fhickman_nosp_at_m_noblesoft.com)
Date: 02/22/04 

Date: Sun, 22 Feb 2004 16:50:23 -0500

You can keep the embedded quotes but you must use the SQL method for
representing them...

Say you have the string "That's how the cookie crumbles." To insert this
string into the field you would have to make the string contain."That'''s
how the cookie crumbles." So you would need to write a function that adds
this or you, something like this...

CString& FixQuotes( CString& strInput )
{
    CString strIn( strInput );
    int nNdx= 0;
    for( int nPos= 0; nPos < strIn.GetLength(): nPos++ )
    {
        strInput[nNdx]= strIn[nPos];
        if ( strIn[nPos] == _T('\'') )
        {
            strInput += _T("''");
            nNdx += 2;
        }
        else
        {
            ++nNdx;
        }
    }
    return strInput;
}

CString strVal= _T("That's how the cookie crumbles.");
strVal= FixQuotes( strVal );

strVal should now contain: That'''s how the cookie crumbles.

This is off the top of my head so you may need to tweak it.

HTH 

-- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"damned" <damned@iol.pt> wrote in message
news:uEXeKsY%23DHA.2592@TK2MSFTNGP10.phx.gbl...
> eheheh (dumb damned)
>
> Now this leads me to another problem...
> I need to insert the quotes also!
>
> Must I first parse the quotes, then insert the data and then, finaly,
parse
> the quotes back again? Or is there a better way to accomplish this?
>
> Regards,
> damned
>
> "Frank Hickman" <fhickman_nosp@m_noblesoft.com> wrote in message
> news:7Zednbl_lrEGE6vdRVn-hw@comcast.com...
> > Glad you got it!  Yep, embedded quotes will get ya just about everytime
:)
> >
> > --
> > Frank
> >
> >
> > "damned" <damned@iol.pt> wrote in message
> > news:eO%23GWJA%23DHA.3648@TK2MSFTNGP11.phx.gbl...
> > > Frank,
> > >
> > > The tags were only for marking script block (wrong choice).
> > >
> > > I've found the problem!
> > > Some of the field data contains the "'" character. So the
concatenation
> of
> > > "INSERT INTO MyTable (Field1) VALUES ('" & strVar & "')" results in
> error!
> > > (''/ab/'').
> > > I must strip all data before insering.
> > >
> > > My first code example missled you. I gave an hardcoded example. Sorry.
> > >
> > > Regards,
> > > damned
> > >
> > > "Frank Hickman" <fhickman_nosp@m_noblesoft.com> wrote in message
> > > news:4qqdnbSBQtoi-6vdRVn-hw@comcast.com...
> > > > Yes they did :)  Are they part of your script or did you just use
them
> > to
> > > > show the start and end of your code?  Or is your script in an html
> file
> > > that
> > > > you want to use ASP in?
> > > >
> > > > Here is my adotest.vbs script which also works...
> > > >
> > > > ****** Start ******
> > > >
> > > > Option Explicit
> > > >
> > > > Dim conDB
> > > > Set conDB = CreateObject("ADODB.Connection")
> > > > With conDB
> > > >     .Open "DSN=MyDatabase"
> > > >     .Execute "INSERT INTO MyTable (Field1) VALUES ('\ab\')"
> > > >     .Close
> > > > End With
> > > > Set conDB = Nothing
> > > >
> > > >
> > > > ****** End ******
> > > >
> > > > --
> > > > Frank
> > > >
> > > > "damned" <damned@iol.pt> wrote in message
> > > > news:ufZd3d%239DHA.1428@TK2MSFTNGP12.phx.gbl...
> > > > > Frank,
> > > > >
> > > > > It's a .vbs administrative script.
> > > > > Maybe using the "<%"/"%>" tags confused you.
> > > > >
> > > > > Regards,
> > > > > damned
> > > > >
> > > > > "Frank Hickman" <fhickman_nosp@m_noblesoft.com> wrote in message
> > > > > news:lMWdnVHj-Lj8SajdRVn-tA@comcast.com...
> > > > > > Okay that confused me.  How are you executing the script?  In IE
> or
> > do
> > > > you
> > > > > > have a command line asp processor?
> > > > > >
> > > > > > "damned" <damned@iol.pt> wrote in message
> > > > > > news:e6x0YG59DHA.4064@TK2MSFTNGP09.phx.gbl...
> > > > > > > Frank,
> > > > > > >
> > > > > > > Thank you for your interest and testing work.
> > > > > > >
> > > > > > > I don't have IUSR_ & IWAM_ accounts on the PC running the
> script.
> > No
> > > > IIS
> > > > > > is
> > > > > > > installed there. It's an administrativ
> > > > Conript.
> > > > > > >
> > > > > > > Regards,
> > > > > > > damned
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Need to use 2 fields in link criteria
    ... quote around SSN so that the full SQL string has the SSN as a literal ... there is intervening text within the quotes. ... > Hi Bonnie, ...
    (microsoft.public.access.formscoding)
  • Re: SQL WHERE STMT PROBLEM
    ... is defined as a String variable, it is therefore not possible for it to ever ... possibly assign the value "False" to the BsSql variable. ... Dim oRst As DAO.Recordset ... > single and dbl quotes as instructed to produce the above BsSql ...
    (microsoft.public.access.queries)
  • Re: Multi Field SQL Where Clause
    ... Trying to DIM variables in a public function when the variables are already DIM'd will generate an error. ... I also struggled with creating the SQL string when I first started. ... Yes, it should have been a single quote, not three quotes. ... sysNtDvNo = sysPUOHDvNo ...
    (microsoft.public.access.forms)
  • Re: fastest way to change case of string
    ... which will show if the string starts with 2 single quotes. ... Sub ChangeCase4(strString As String, bUpper As Boolean) ... Dim lLenString As Long ... However, so my effort was not a total waste, below is the solution I came up with (and, amazingly enough, I had called my function ChangeCaseX also). ...
    (microsoft.public.vb.general.discussion)
  • Re: understanding arrays, and their use
    ... The fourth field can be a string enclosed in quotes with either a file path, or multiple words separated by spaces. ... Now, separate a line into four groups, with whitespace separating them. ... set filehandle ...
    (comp.lang.tcl)