This is a multi-part message in MIME format.



------=_NextPart_000_002E_01C16B62.C07B2EF0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



i have a table 'n field using uniqueidentifier datatype ,

field name =3D vid

field datatype =3D uniqueidentifier.



then in asp , i make a query that select it ,

sql  =3D "select vid wher vid =3D'" request.form(id") &"'"

but i get error on it. the error say that i couldn't convert char to 

uniqueidentifier ,

if i user number in id , i couldn't to....



Any suggestions would be very welcome

Your SQL statement is incorrect...



sql = "select vid where vid = '" & Request.Form("id") & "'"





-----Original Message-----

From: helmy [mailto:helmy@s...]

Sent: Sunday, November 11, 2001 10:14 PM

To: ASP Databases

Subject: [asp_databases] uniqueidentifier datatype





i have a table 'n field using uniqueidentifier datatype ,

field name = vid

field datatype = uniqueidentifier.



then in asp , i make a query that select it ,

sql  = "select vid wher vid ='" request.form(id") &"'"

but i get error on it. the error say that i couldn't convert char to

uniqueidentifier ,

if i user number in id , i couldn't to....



Any suggestions would be very welcome










$subst('Email.Unsub')