"cfps.Christian" <ge0193***@otc.edu> wrote in message
news:09ed402f-8bd8-4d37-b5f9-b8104d900a52@e1g2000hsh.googlegroups.com...
> I'm creating a program that uses the GUID as found in the database to
> determine what information to display on the page.  I pass in the guid
> though the url and then I was going to use it to query the database.
>
> strGuid = Request("Guid")
> strSQL = "SELECT * FROM Questions WHERE Key = ?"
> oCMD.Parameters.Append oCMD.CreateParameter("@Key", adGuid,
> adParamInput, 16, strGuid)
>
> I get an error "Application uses a value of the wrong type for the
> current operation." when I attempt to execute the statement.  How can
> I query this using the parameters and passing in the Guid?
>
> I tried copying the guid to a byte array and had the same problem.

On Nov 16, 1:45 pm, "Ralph" <nt_consultin***@yahoo.com> wrote:
> "cfps.Christian" <ge0193***@otc.edu> wrote in message
>
> news:09ed402f-8bd8-4d37-b5f9-b8104d900a52@e1g2000hsh.googlegroups.com...
>
> > I'm creating a program that uses the GUID as found in the database to
> > determine what information to display on the page.  I pass in the guid
> > though the url and then I was going to use it to query the database.
>
> > strGuid = Request("Guid")
> > strSQL = "SELECT * FROM Questions WHERE Key = ?"
> > oCMD.Parameters.Append oCMD.CreateParameter("@Key", adGuid,
> > adParamInput, 16, strGuid)
>
> > I get an error "Application uses a value of the wrong type for the
> > current operation." when I attempt to execute the statement.  How can
> > I query this using the parameters and passing in the Guid?
>
> > I tried copying the guid to a byte array and had the same problem.
>
> How is it formatted?
> It should be a string with braces....
> "{8CA3A28C-311D-4FEA-A30D-5A4BB71E7278}"

"cfps.Christian" <ge0193***@otc.edu> wrote in message
news:5c4588c4-5010-4a76-ba66-bd05e514f6ed@b36g2000hsa.googlegroups.com...
> On Nov 16, 1:45 pm, "Ralph" <nt_consultin***@yahoo.com> wrote:
> > "cfps.Christian" <ge0193***@otc.edu> wrote in message
> >
> > news:09ed402f-8bd8-4d37-b5f9-b8104d900a52@e1g2000hsh.googlegroups.com...
> >
> > > I'm creating a program that uses the GUID as found in the database to
> > > determine what information to display on the page.  I pass in the guid
> > > though the url and then I was going to use it to query the database.
> >
> > > strGuid = Request("Guid")
> > > strSQL = "SELECT * FROM Questions WHERE Key = ?"
> > > oCMD.Parameters.Append oCMD.CreateParameter("@Key", adGuid,
> > > adParamInput, 16, strGuid)
> >
> > > I get an error "Application uses a value of the wrong type for the
> > > current operation." when I attempt to execute the statement.  How can
> > > I query this using the parameters and passing in the Guid?
> >
> > > I tried copying the guid to a byte array and had the same problem.
> >
> > How is it formatted?
> > It should be a string with braces....
> > "{8CA3A28C-311D-4FEA-A30D-5A4BB71E7278}"
>
> its formatted however I want it to be, I really haven't written the
> code to input it yet

"Steve Gerrard" <mynameh***@comcast.net> wrote in message
news:5tWdnXGWkLdcA9banZ2dnUVZ_rGrnZ2d@comcast.com...
>
> "cfps.Christian" <ge0193***@otc.edu> wrote in message
> news:de3fbdba-204f-46e4-adb5-e3d02583da40@e4g2000hsg.googlegroups.com...
> > For those that read this later I solved my problem by cheating.
> >
> > In my Select statement where I put the parameter that was the guid I
> > simply put Cast(? AS UniqueIdentifier) and passed in the variable as a
> > varchar.
> >
> > oCMD.Parameters.Append oCMD.CreateParameter("@Key", adVarchar,
> > adParamInput, 40, strGuid)
>
> For those that read this later, I don't think that is cheating at all. :)
>
> You are starting with a string containing a Guid. Passing that along, and
> converting it at the point it needs to be converted, makes perfect sense,
and
> avoids the possibly awkward business of passing a real Guid as a SQL
parameter.
> Strings are a good safe territory for this sort of thing.
>