This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » procedure check then insert

procedure check then insert
saraa samir Member Since: 07 Dec 2008 Posts: 5	Posted 07 Dec 2008 05:53:35 Hi i have table with three coulmns(name , phone , ishere as boolean) i need to create procedure that check name if not exists insert anew record & if exist delete the insert thank u Hi i have table with three coulmns(name , phone , ishere as boolean) i need to create procedure that check name if not exists insert anew record & if exist delete the insert thank u
saraa samir Member Since: 07 Dec 2008 Posts: 5

Roddy Dairion Zone Manager Since: 12 Oct 2005 Posts: 441	Replied 10 Dec 2008 18:57:16 1. Are you using PHP, ASP or something else with SQL to do this???? 2. What if you have 2 john how does it work??

saraa samir Member Since: 07 Dec 2008 Posts: 5	Replied 11 Dec 2008 01:16:26 <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> 1. Are you using PHP, ASP or something else with SQL to do this???? 2. What if you have 2 john how does it work?? <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> Hi Roddy i am not using anything but sql i already found the answer thank u

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!

Forums

procedure check then insert

Hi

i have table with three coulmns(name , phone , ishere as boolean)

i need to create procedure that check name if not exists insert anew record
& if exist delete the insert

thank u