|
I think It is using GUIDs as the identity column.
GUIDS have hyphens and I 'ont whant no mur hypens.
|
|
|
|
|
Actually GUIDs have no hyphens (these are numbers after all), it just happened that we mostly display it such way to help our eyes...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
But, when you query the DB (SQL Server) you get a value back for your (uniqueidentifier) identity which looks like:
BF5B2C5A-8E79-4FA0-8510-B3FD6BC819D6 (uniqueidentifier)
Right? So if you then try to do something with that value you would have hyphens and I was thinking that is what was hanging him up?
|
|
|
|
|
Yes, SQL - and others too - turn GUID into string...
If you read the RFC[^] you will understand why, but after all GUID is a 128 bit number...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: but after all GUID is a 128 bit number
Agree 100%.
Was just speaking about hyphens in this case with Guid identities in SQL.
|
|
|
|
|
Read the guidlines: "Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid.. "
Bruno
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Yeah, yeah, I know them.
I'm allowed to lose my cool every now and then.
|
|
|
|
|
Before you can lose something, you must have it first.
Bruno
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Developers have to first help others to help them.
This guy just isn't doing that and, much as profanity is (usually) unwelcome here, he deserved his put-down IMO.
|
|
|
|
|
"When I was 5 years old, my mother always told me that happiness was the key to life. When I went to school, they asked me what I wanted to be when I grew up. I wrote down 'happy'. They told me I didn't understand the assignment, and I told them they didn't understand life." - John Lennon
|
|
|
|
|
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Are you talking about a Guid here? Do you want to remove the hyphen from a Guid? You can convert the Guid to a string and replace the - with "" to remove the hyphen.
|
|
|
|
|
|
Sweet. That's what I learned today.
Regards,
Rob Philpott.
|
|
|
|
|
So?
public string ToString("N")
|
|
|
|
|
|
|
|
how add i you to friendlylist?
|
|
|
|
|
I'm not sure what a friend list is in CP terms. If you post a question and I can help, I'll generally try to do so, so there's no need to have a friend list there.
|
|
|
|
|
okay thank you
|
|
|
|
|
+5 for the tip! This will be useful! 
"Go forth into the source" - Neal Morse
|
|
|
|
|
Yes
|
|
|
|
|
I have have a textbox with id that is connected (local database relation) to gridview and that save hyphen als this -1. I have not a string?
|
|
|
|
|
What is the datatype of the identity-field? Is it a BIGINT?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
