Problems with GUID as querystring parameter

Report · Apr 18, 2006

Greetings - longtime ASP guy just getting started with ASP.NET - I have always preferred using Dreamweaver over Visual Studio - but I am having some issues getting going.

It looks like when I use the Bindings tab to create a query to my SQL database - it always chokes if a I select a GUID as the querystring parameter. Any other type of value seems to work fine in my quieries. I would abandon the GUIDs but I didn't design the database and I'm stuck.

Here is a sample of what I am running into:

System.Exception: Unsupported TYPE attribute: guid
at DreamweaverCtrls.DataSet.GetDbTypeFromString(String str)
at DreamweaverCtrls.DataSet.AddParameters(IDbCommand myCommand)
at DreamweaverCtrls.DataSet.DoInit() Text

I notice Dreamweaver builds it's queries differently from VS 2005 - and registers some custom controls. I have tried to instantiate my connection in VS2005 and import it to Dreamweaver, and the query will work, but I don't get all the neat drag and drop server behaviors.

Oh yeah - working in XP SP2 - DotNet framework 2.2, MX 2004

Any ideas would be great.
JKM

Report · Apr 18, 2006

> Greetings - longtime ASP guy just getting started with ASP.NET - I have
> always
> preferred using Dreamweaver over Visual Studio - but I am having some
> issues
> getting going.

If you're moving to .net, you really should consider moving to VS. You don't
have to get rid of DW, but VS is definitely designed for .net development.

> System.Exception: Unsupported TYPE attribute: guid
> at DreamweaverCtrls.DataSet.GetDbTypeFromString(String str)
> at DreamweaverCtrls.DataSet.AddParameters(IDbCommand myCommand)
> at DreamweaverCtrls.DataSet.DoInit()Text

I don't use DW's controls, but the error is coming from there, obviously.

My guess is that it's trying to pass the QS as a STRING in the SQL query
rather than as a GUID field.

-Darrel