data type error
Posted on 2004-05-01
my database useroid is numeric, however the way i setup the cookies and application, a UUID useroid is created! thus i get a useroid mismatch when trying to query the database. could someone tell me how i can fix the cookie to make it numeric as well, below is the code from my application.cfm
* set a default UUID cookie, for demo purposed this is a temp cookie.
* But is usually a never-expiring cookie.
* this UUID is also the primary key of the user in the database.
<cfif not isDefined("cookie.petmarketuseroid")>
<cfcookie name="petmarketuseroid" value="#createuuid()#">
<cfif not isDefined("session.user") or session.user.useroid neq cookie.petmarketuseroid>
session.user = createObject("component", "petmarket.user");