I have a session handler class that calls session_write_close() at the end of the script. This insures that even if a header() or exit() is issued the session data is saved. public function __destruct() { session_write_close(); } However, I have noticed that for one of my AJAX pages TWO session updates are committed by the databas...
I've asked about each of these technologies separately, and really haven't found a suitable answer. We have a server in our central office running SQL Server 2005 Enterprise that has several large (large in the sense that DSL is the limiting factor) databases that we need local copies of at each of our locations. We currently have a fe...
Hi GUys, Im trying to save a record to a table aswell as an accociated record. The main table is called quotes and it has a hasmany link to the table quote_items. quote_items belongsto quote When i try and save it saves the record in quote but does not save the record in quote_items . Below is my quote add function function add(...
As far as I know (this page) Oracle automatically creates an index for each UNIQUE or PRIMARY KEY declaration. Is this a complete list of cases when indexes are created automatically in Oracle? ...
Hi Guys I'm creating an online music store application (in Java) for signed and unsigned artist for my client. I'm currently using Struts 1.3.10 (I was recommended Spring but Spring setup is sort of similar to Struts) for my Web application. My Database is currently a MySQL 5 (or higher) and I'm using a DAO pattern to talk to it. Ther...
If you have a Rail app with many complex associated models, what techniques do you employ to reduce database queries? In fact, I'll extend that question a little further and ask, what do you consider "too many" queries for any page? I have a page that I expect will end up hitting the database about 20 times each page load. That concern...
I'm making desktop application (lets call it app) which uses database (mysql). More app's users share one database user. Example : John and Mike app users connect to DB as "dbuser", etc. The problem is : How do I effectively save passwords for DB users? (app users's pwds are stored in DB). Possible solutions I found : 1. in the code -...
I'm kinda ashamed of asking this since I've been working with MySQL for years, but oh well. I have a table with two fields, a and b. I will be running the following queries on it: SELECT * FROM ... WHERE A = 1; SELECT * FROM ... WHERE B = 1; SELECT * FROM ... WHERE A = 1 AND B = 1; From the performance point of view, is at least one...
I have three forms similar to the one in the link. I want add a Total textbox to every form. The total will add the values that will be entered in the montant textbox. So the total will take the specific value of that texbox for all the entries that the user will have and add them. How I can do so???? Thanks http://i1006.photobucket.co...
Hi, Basically my job is to develop web applications using a database as backend. What I have been doing till now is, Basded on the requirement of the client, I draw a basic sketch of what the tables are ,how they look like fields in those tables and some one-to-one or many-to-one or many-to-many relations Although I am not perfe...
I keep getting this error when I try and use a MS Access database in my application: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. After Google'ing the error for a while I came to see that this is a problem when running the application in 64-bit mode. If I was to compile the app in 32-bit it wou...
I have two databases in use in a Ruby on Rails application; one is the database for the application while the second is an independent database over which Rails is not given control. Problem is when loading fixtures into the dev, it tries to run DELETE statements on the tables in the independent database from the connection to the dev d...
I am looking for a free database (csv, tab delimited, xml, etc) or even a web service or API which will allow me to query for business listings within a certain distance of a latitude and longitude. A global scope would be perfect, but I would settle for Canada/US information. Does anyone know of anything like this? ...
I have started working on a project in the financial services industry that is based (mainly) on SQL Server (2000), ColdFusion (8), and some Access/.NET applications. This project started as some simple Access forms/VBA and was slowly converted to web interfaces. I could say that the database design and application coding was done by pe...
Thanks to Anthony's advice I've tried to simplify my logic and syntax of the goal I am trying to achieve which is when a blog is written, the AUTHOR gets notified by php mail that someone other than himself comments. When the AUTHOR comments everyone else who commented except him gets a different email. When another user comments, the AU...
We have multiple offices, and within each office there are multiple departments (some departments have employees in multiple offices). We have two existing systems that identify employees in different ways: in one, employees are identified by IDA; in the other employees are identified by IDB. In the cases where an employee is identifie...
I have a form set up where I want to run the function PopulateGrid on it's Form_Load event. I have initialized the DB connection as follows: Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load LoadConfigFile() cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Sourc...
I've been reading about XML, XSL, XPath, etc. I want to start this small script in PHP using XML as the database to create a simple CRUD app. I will be using SimpleXML but after reading some answers over stackoverflow it seems many people suggest DOMDocument (is there anything that benefits using DOMDocument more than SimpleXML?) Anywa...
I have a .IB file which I'd like to access using a Java Application. Where can I find the drivers for Interbase. My OS is Mac OS X ...
i have 50 checkboxes for 50 american states. The user can choose all 50 or only 1( so basically any number he wants). Based on his choice, I want to insert or update the table in sql server 2008. e.g- Color = blue and chk1=check, chk2= check and chk3 = check (chk = checkbox). now the user wants to ad 10 more states to this or remove the...