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?

DELETE FROM users
        WHERE
        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..

Cheers

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The Door to Coldfusion Community
Will Remain Open Till World Ends

Want a Web Portal Contact Me

randhawaz81@gmail.com

<cf_visitwebsite>

http://portal.randhawaworld.com/

</cf_visitwebsite>


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
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=31&Topic=13913