Passing ID's in SQL

Andrew Banks

unread,

Feb 15, 2004, 2:02:58 PM2/15/04

to

I'm using guid to generate primary keys for my SQL server DB

I'm now trying to query the DB but keep getting errors. It seems to be
erroring when passing the ID and it's always around a hyphen in the sring
I'm passing

Eg.

WHERE ID = '24646a31-c088-41da-b93c-32174588da48' errors near a31
WHERE ID = 'f7a9b89a-cbf6-4f40-aafe-7a861214ddcc' errors near f40
WHERE ID = '30328414-3e2a-4244-9163-e0384afe8b5a' errors near a

Can anyone help on this?

Are you supposed to escape the - in some way?

Thanks

William (Bill) Vaughn

unread,

Feb 15, 2004, 3:30:04 PM2/15/04

to

Let's see how you're setting up the SQL in code. I suspect you're not using
a Command object and parameters.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Andrew Banks" <ban...@nojunkblueyonder.co.uk> wrote in message
news:CnPXb.5031$Fk.50...@news-text.cableinet.net...

Andrew Banks

unread,

Feb 15, 2004, 4:08:59 PM2/15/04

to

Bill,

Your comments made me re-check what I'd done. I had built the sql ok but
missed out the ' and ' either side of the ID I was passing.

I guess we all do it - look at our code that long we miss even the most
obvious of mistakes.

"William (Bill) Vaughn" <billvaRe...@nwlink.com> wrote in message
news:ONHp9JA...@tk2msftngp13.phx.gbl...

William (Bill) Vaughn

unread,

Feb 18, 2004, 12:18:08 PM2/18/04

to

I have my wife (generally computer agnostic) try all my samples. She usually
breaks them in ways no one could imagine. Isn't that what "extreme"
programming is all about? Another set of eyes always helps.
Glad you got it working.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Andrew Banks" <ban...@nojunkblueyonder.co.uk> wrote in message

news:LdRXb.5152$DR.50...@news-text.cableinet.net...