DMXzone Database Updater ASP Support Product Page

Solved

Error inserting GUID

Reported 16 Jan 2015 21:42:49
1
has this problem
16 Jan 2015 21:42:49 Chris Turner posted:
I am trying to insert a GUID using the Database Updater Control. This is the error I'm getting:

Error with parameter 1 with value {BD9DA380-CBA3-46AC-B10C-FE6FBFBC495A}: Parameter object is improperly defined. Inconsistent or incomplete information was provided.

I have tried using both Varchar 100 and uniqueIdentifier as the datatype in my SQL Server 2008 database. I am trying to insert an ASP session variable:
<%= Session("LocationID" %>
This is the way my data is formatted before I try to insert it:
{BD9DA380-CBA3-46AC-B10C-FE6FBFBC495A}

I was able to insert a GUID when using a drop down list populated with a repeater datasource. Here is an example:
<option value="{{PalletCategoryID}}">{{PalletCategory}}</option>
I was able to insert this value. Seems when I try to use the classic asp code, it will not work.
Please advise, as we use lots of GUID types.

Replies

Replied 20 Jan 2015 01:16:56
20 Jan 2015 01:16:56 Chris Turner replied:
In addition to the main issue above, I am also having the same issue with filter in the Database Source QueryBuilder. I try to filter a table select with an entered value of a GUID, and I still get the same error. I also get the same error if I try to filter using session data with a GUID. I have no issues however returning data with a GUID in a straight select statement. I have tried enclosing my GUID with {}, with ' ' and with quotes " ". Everything points to my GUID not being formatted correctly or somewhere my DataType is off, but I have checked and is 17, 16.

Any help would be appreciated. If I can't find a solution, I will have to revert back to the deprecated ASP classic controls.
Thanks,
Chris
Replied 20 Jan 2015 15:01:02
20 Jan 2015 15:01:02 Teodor Kuduschiev replied:
Hello Chris,
Please send us a link to your page to
Replied 30 Jan 2015 18:56:51
30 Jan 2015 18:56:51 Chris Turner replied:
With the help from support, here is a work-around.
Go to ScriptLibrary>sqlbuilder.asp file and change the typeMapping from 72: 200 to 72: 72. Mine happen to be on line 71 Works if you are having issues with inserting or filtering data in your data connections using GUIDs.

Thanks,
Chris

Reply to this topic