2. ASPRunnerPro General questions
  3. ASP Error with unique id
This topic is locked

ASP Error with unique id

 		4/8/2003 13:46:58
ASPRunnerPro General questions
author

I get the following error using ASP Runner trying to add new records that have the primary key sat to uniqu identifier:
Error number -2147217900

Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting from a character string to uniqueidentifier.
Any help, thanx in advance for your time
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=47&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Sergey Kornilov admin 4/8/2003

Hi,
could you post your SQL query here that causes this error?
Sergey Kornilov
500025 4/9/2003

Here is an example:
insert into [dbo].[Processing] (Record_ID, Serial_Number, EmployeeID_process, Processor, Processor_QTY, Ram, CDRom, Floppy_Drive, Power_Supply, Condition_Grade, Date_Processed, Model#, EmployeeID_Auditor, Cleaned, EmployeeID_Clean, Recycled, Recycling_Weight, EmployeeID_recycle, Shipped_With_KB_Mouse_PowerCord, ShippingRecord#) values ('', '65461', '001', 'PIII550', '1', '1024', 1, 1, 0, 'A', '', 'GX200', '001', 0, '', 0, '', '', 0, '')
Thanx for your help

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=145&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />
Sergey Kornilov admin 4/9/2003

Hi,
I found some problems with GUID fields processing.

Please wait couple of days while I fix this problem.
Sergey Kornilov
500026 4/10/2003

Thanx for the quick response, I will wait for your fix.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=148&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Sergey Kornilov admin 4/11/2003

Tekguy4,
please send me your email address to support AT xlinesoft.com where I can send you link a new beta version.
Sergey Kornilov
500027 4/15/2003

Same error message with the new version, error converting from character string to unique identifier
Any suggestions?
Thanks again for your time

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=157&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
500028 4/15/2003

Hi,
I'm out of office right now. Will be back to you next week when I get back.
Sergey Kornilov
500029 5/11/2004

Try converting the UniqueID into character before doing a compare.
CONVERT(char(255),st.GUID)
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=1798&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />