Topic: a issue with mysql or my mistake

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)

update userid
set userid  = null
where userid in ('form.userid')

then i make th delete query?

        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 :