uniqueidentifie r in SQL Query

[Kenneth Keeley]

Hi,
I am trying to get the results out of an SQL database where the Id is
equal to a given value. The Id field is a uniqueidentifie r this is what I am
trying to do.

SQLQuery = new SqlDataAdapter( "SELECT Id, Title, Publication, InsertDate,
NoPages, Colour, Status " +
"FROM Features WHERE Id={guid {" + Request.QuerySt ring[ "id" ] + "}};",
DataBaseConnect ion);

The Querystring value looks like this "3B9767E0-56DD-49FB-8CC0-79A8FE95CEFF"

I keep getting errors and I would like to find a sample of how to do this.

Thanks
Kenneth.

[Lucas Tam]

"Kenneth Keeley" <ke*******@hotm ail.com> wrote in
news:uT******** ******@TK2MSFTN GP09.phx.gbl:

The Querystring value looks like this
"3B9767E0-56DD-49FB-8CC0-79A8FE95CEFF"

I keep getting errors and I would like to find a sample of how to do
this.

You need to encapsulate your ID like:

ID='{3B9767E0-56DD-49FB-8CC0-79A8FE95CEFF}'.

Make sure you have the single quotes and curly brackets.

To insert into a GUID field, you need to use the NewID() function to
generate a GUID.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Greg Burns]

(untested)

Dim cmd As New SqlCommand("SEL ECT Id, Title, Publication, InsertDate,
NoPages, Colour, Status FROM Features WHERE Id=@guid", DataBaseConnect ion)

cmd.Parameters. Add(New SqlParameter("@ guid", SqlDbType.Uniqu eIdentifier,
16)).Value = New Guid(Request.Qu eryString("id") .ToString)

Dim da as New SqlDataAdapter( cmd)

Greg

"Kenneth Keeley" <ke*******@hotm ail.com> wrote in message
news:uT******** ******@TK2MSFTN GP09.phx.gbl...

Hi,
I am trying to get the results out of an SQL database where the Id is
equal to a given value. The Id field is a uniqueidentifie r this is what I
am
trying to do.

SQLQuery = new SqlDataAdapter( "SELECT Id, Title, Publication, InsertDate,
NoPages, Colour, Status " +
"FROM Features WHERE Id={guid {" + Request.QuerySt ring[ "id" ] + "}};",
DataBaseConnect ion);

The Querystring value looks like this
"3B9767E0-56DD-49FB-8CC0-79A8FE95CEFF"

I keep getting errors and I would like to find a sample of how to do this.

Thanks
Kenneth.

[Kenneth Keeley]

Thanks that fixed it.

"Lucas Tam" <RE********@rog ers.com> wrote in message
news:Xn******** *************** ****@140.99.99. 130...

"Kenneth Keeley" <ke*******@hotm ail.com> wrote in
news:uT******** ******@TK2MSFTN GP09.phx.gbl:

The Querystring value looks like this
"3B9767E0-56DD-49FB-8CC0-79A8FE95CEFF"

I keep getting errors and I would like to find a sample of how to do
this.

You need to encapsulate your ID like:

ID='{3B9767E0-56DD-49FB-8CC0-79A8FE95CEFF}'.

Make sure you have the single quotes and curly brackets.

To insert into a GUID field, you need to use the NewID() function to
generate a GUID.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/