questions. I'm making my first record.
I'm trying to add a uniqueIdentifier to a db. I have the column
defined fine (i think). I've added the input 'identifier' to my form
and filled it with:
<input name="identifier" type="hidden" value = "#CreateUUID()#"/>
When I check the source it seems to have a valid uniqueIdentifier,
but when I try to pass this to the db, I get the error, "Syntax error
converting from a character string to uniqueidentifier."
Also, It seems that to use cfinsert, I have to be inserting from a
form. I expect that I won't always be doing that, since later in the
week I'll be using cf to save flash data.
Finally, to check to see if it's a duplicate name do I first do a
query and if it's larger than 0 returned then it's not unique?
Sorry for asking the basics. Any tutorials on this would also be helpful.
thanks.
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
