Re: PHP MYSQL and Apache Issue
- From: "Ricks Place" <OFBGMail@xxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 21 Nov 2008 04:34:22 -0500
Hi Punit:
Is the value from the second select statement being lost after the PostBack
and Prior to the DataBase Execution or after the DataBase execution?
In other words, you build a Select Statement either on a WebPage or in
CodeBehind with a parameter, then execute that statement somehow. Exactly at
what point is the second parameter being lost? It could be a Session Problem or
a DataBase Problem. You should be able to enable Table or Row Locking to
eliminate any concurrency problems but because the actual value of the Select
Statement is being changed it does not sound like a DataBase Concurrency
problem as I understand them.
Exactly where is the Select getting messed up?
You have a Webpage executing on the Client computer gathering the details for
the query: Then, Pass the parameters to a module running on the Host Server
during a PostBack: Then, Build and Request Db Services with those Passed
Parameters: Finally, Pass a Select Statement with the Passed Parameters to the
DataBase Server or Framework:
The last thing is to test the results of the Select Statement which should be
one or more records if any hits were found.
Tracking your original parameters through the logic flow where are they
getting lost or messed up?
Rick USA
----- Original Message -----
From: Punit Diwan
To: programmingblind@xxxxxxxxxxxxx
Sent: Friday, November 21, 2008 1:05 AM
Subject: PHP MYSQL and Apache Issue
Hi Members,
I am using LAMP. During multiple access MySQL Error comes
when more than one persons tries to access the site. The reason is the data
entered by user is not reaching to the database. Eg Select * from Products
where the product_name = 'Bike' turns to:
Select * from Products where the product_name =''. This happens only when
more than one person access the website. Is it concurrency issue? Please
suggest how to solve this.
Punit Diwan
Tata Consultancy Services
Ph:- 04712519400
Cell:- 09826092262
Mailto: punit.diwan@xxxxxxx
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
Other related posts:
