Question
Problems with GUID as querystring parameter
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
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
AdChoices