This is still a little unclear. You want to check the query to see if it can be run succesfully, or that it RAN succesfully. Perhaps I should as if you wish to check the query before or after it runs?
Later on, Terrence (BDKR) ----- Original Message ----- From: "mustafa karabulut" <[EMAIL PROTECTED]> Date: Sat, 04 May 2002 16:36:33 +0300 To: [EMAIL PROTECTED] Subject: Re: Parsing SQL statements > Thanks for your reply. > I meant the second, to check the query whether it can be executed > succesfully. > Seems transactions are needed, is there any other way ? > > > > >From: "Terrence Cox" <[EMAIL PROTECTED]> > >To: "mustafa karabulut" <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: Parsing SQL statements > >Date: Sat, 04 May 2002 21:30:54 +0800 > > > >Just to make sure I understand you, you need to check the sql statements > >themselves for errors. Is this correct? > > > >Or, do you instead need to check that a query ran with success? > > > >Late on, > >BDKR > > > >----- Original Message ----- > >From: "mustafa karabulut" <[EMAIL PROTECTED]> > >Date: Sat, 04 May 2002 12:42:26 +0300 > >To: [EMAIL PROTECTED] > >Subject: Parsing SQL statements > > > > > > > Hello, > > > > > > I need sql statements parsed before they are sent to be queried. I > > > know-though I am not sure- mysql does these steps: > > > > > > 1-Parse sql statement,check for errors > > > > > > 2-execute the statement > > > > > > Is there a way to intrude in between step1 and step2 so that we could > >get > > > sql statement parsed without it is executed ? > > > > > > A few people recommended me to do it by transactions, to query first and > > > rollback your work after the query is performed succesfully. But you > >know > > > disadvantages of transaction safe tables and my tables are already non > > > trans. safe and if there is a way to parse sql statements then I will > >get > > > rid of lot of work. > > > > > > I need your help. And of your help and suggestions are very appreciated. > > > > > > Best regards > > > > > > M.K. > > > > > > > > > > > > _________________________________________________________________ > > > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > >-- > > > >_______________________________________________ > >Download the free Opera browser at http://www.opera.com/ > > > >Powered by Outblaze > > > > > _________________________________________________________________ > Join the world?s largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- Powered by Outblaze --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
