Re: Wrong sintax...? GOT IT!
From: damned (damned_at_iol.pt)
Date: 02/22/04
- Next message: Peter Plumber: "adodb.recordset.save and back"
- Previous message: Neil Robbins: "Re: Problem changing password using ADOX.Catalog.Users(User).ChangePassword"
- Next in thread: Frank Hickman: "Re: Wrong sintax...? GOT IT!"
- Reply: Frank Hickman: "Re: Wrong sintax...? GOT IT!"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 22 Feb 2004 21:30:44 -0000
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
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Peter Plumber: "adodb.recordset.save and back"
- Previous message: Neil Robbins: "Re: Problem changing password using ADOX.Catalog.Users(User).ChangePassword"
- Next in thread: Frank Hickman: "Re: Wrong sintax...? GOT IT!"
- Reply: Frank Hickman: "Re: Wrong sintax...? GOT IT!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
