Re: Stubborn syntax for a variable
From: Fox (_at_)
Date: 07/12/04
- Next message: Bob Castleman: "ms.public.sqlserver.server group dead?"
- Previous message: Scott Morris: "Re: CROSS-TABULATION Help needed - PLEASE!"
- In reply to: Aaron [SQL Server MVP]: "Re: Stubborn syntax for a variable"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 12 Jul 2004 14:46:10 -0400
I wasn't being obscure. Each try came up with different
error messages. Sorry for not be more explicit.
Actually, it now works. There is no visible reason why
since it is not different then it was.
After I posted I remembered that it was pasted from another
page where it worked fine. And I also remember having this
same problem once before. Even though it is the same visibly,
it works now and did not before. I retyped it and went back
to the value and then again to the varible many times
and eventually it just worked.
BTW the error message from the specific example was
Multiple-step OLE DB operation generated errors
Thanks,
Fox
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:%23j%23zowDaEHA.3508@TK2MSFTNGP09.phx.gbl...
> What does "nothing I try will work" mean? Are you getting an error
message?
> If so, what is it? Is it coming from your ASP code, or from SQL Server?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Fox" <fox @ connexions .net> wrote in message
> news:OuBXlrDaEHA.2520@TK2MSFTNGP12.phx.gbl...
> > I am having a problem replacing a value with a variable.
> >
> > This works
> > Set objInsertResults = Server.CreateObject("ADODB.Recordset")
> > objInsertResults.Open "FBBAPoints", db_flmaConnect ,2,3
> >
> > This does not work
> > Set objInsertResults = Server.CreateObject("ADODB.Recordset")
> > objInsertResults.Open onlySBP, db_flmaConnect ,2,3
> >
> > I use this same variable
> > onlySBP = "FBBAPoints"
> > in other queries/statements but
> > in this type of syntax, nothing I try will work.
> >
> > I've tried setting it off with ambersands and I've
> > tried using triple quotes on each side and tried
> > single quotes within double quote set off by
> > ambersands.
> >
> > Can someone shed some light?
> >
> > Thanks,
> > Fox
> >
- Next message: Bob Castleman: "ms.public.sqlserver.server group dead?"
- Previous message: Scott Morris: "Re: CROSS-TABULATION Help needed - PLEASE!"
- In reply to: Aaron [SQL Server MVP]: "Re: Stubborn syntax for a variable"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
