|specific||-- 12-05-2008 @ 9:29 PM|
Hi guys, I am trying to delete the user. my User gets deleted successfully.
my userid is realted to table2 which has refernce of userid.
I mean like i have 3 records and 2 records are related to userid 2.
now i delete userid 2, i want that also in should reflect that thinh in table 2.
I want it should update the table 2 userd value to null where userid was 2.
i am trying to do it in 2 queries but it is now working.
no err is tthrown,
first query make update using in operator (i think my query structure is wrong)
set userid = null
where userid in ('form.userid')
then i make th delete query?
DELETE FROM users
userid = <cfqueryparam cfsqltype="cf_sql_numeric" value="#trim(arguments.userid)#">
can u please tell me how this structure can be achieved.
well i am no good at procedures. if this can be done through procedures, can anybody tell how can it done..
The Door to Coldfusion Community
Will Remain Open Till World Ends
Want a Web Portal Contact Me
|weathermanfsu||-- 01-16-2009 @ 12:44 PM|
Looks like you posted this in the wrong forum - try the mysql forum. You posted this in the MS SQL forum for SQL Server.
|EasyCFM.COM ColdFusion Forums :||http://archive.easycfm.com/forums|