Hello, I am working on an e-commerce website (directing) where the inventory database needs to be fed from the POS database. The current one that company has was built with lotus (Customized) about 10 years ago and not sure if is just the matter of upgrading this POS being done in lotus and build something on the middle that can synchr...
In my master page I have: MembershipUser thisUser = Membership.GetUser(); loggedInUserID = thisUser.ProviderUserKey.ToString(); thisUser gives me access to all the fields in aspnet_Membership. I want a new field, isSubscribed for each user. I can use an SQL query to fetch the value fine, but I want to know if there is someway to mod...
i have a table that has a cell containing a timestamp when the entry was created, than i have a cell containing the number of days that row should expire, something like this my_tb: id | elem1 | timestamp | maxdays | active 1 | jondoe | 2010-09-28 | 60 | 1 1 | foo | 2010-09-18 | 30 | ...
The subject line says it all. Googling DAL & DAO returns only C# .NET related results. Is there a DAL/DAO equivalent pattern in the Java world? Are there any reference implementations available? ...
I'm attempting to exit a while loop, based on file contents. File exists and is empty, or garbage filled at initialization of the program. I externally modify the file, and would like the loop to exit upon this happening based on how the file was modified. Currently, I start a few threads, open the file that I'm reading from. Check the ...
I have a jobs table, and am trying to get a count of jobs for different time frames. My current query looks like this: SELECT COUNT(*) AS 'count', WEEK(j.created_at) AS 'week', MONTH(j.created_at) AS 'month', YEAR(j.created_at) AS 'year', DATE_FORMAT(j.created_at, '%y') AS 'short_year' FROM jobs j WHERE j...
Just wondering if anyone knows of a C++ library that provides a single interface for querying database schema (tables, fields, field types), and for a variety of vendors? I know DTL does this to some degree, although I haven't dug into the details of how it does it, or if it makes that info available external to itself. *ODBC is probab...
Imagine you have 2 applications Application A and Application B. Basically I would like to insert records that exist in Application A into Application B. Sql Server Reporting Server is available on Application A And I was wondering if it is possible to build a report that gathers the record that I need and then publish it as a web serv...
This may be an impossible question - but if anyone has any ideas, even if it's a bespokely written solution We're trying to come up with an idea for a simple program to send out to people, backed by a database. At a simplistic level, there will be a "User" object, which just has name and email. The program just allows someone to edit ...
I have 2 objects. Player and Match. Player is a child of Match. I want to know if I can create both of these at the same time without inserting id's manually. i.e. $match = ORM::factory('match'); $player1 = ORM::factory('player'); $player2 = ORM::factory('player'); $player1->match = $match; $player2->match = $match; $match->save(); ...
I want to store code similar to how jsfiddle stores code. I currently use Postgres for my main database but I'm wondering if it's more ideal to be using a NoSQL database? Code snippets for now will have just one author, but in the future there may be multiple authors and I want the ability for reverting as well. I know there are key/va...
I have two tables: Table A ID ABC_ID VAL Table B ID ABC_ID VAL These two tables are directly related to each other through the ABC_ID column. I want to find all the VAL column values in table A which are not present in table B for the same ABC_ID. ...
Currently doing a test plan for a system. May I know what are the ways to test a database? How do I test whether the database is a good database? And how do I stress test a database? ...
If I want to fetch million rows in hibernate, how would it work? Will hibernate crash? How can I optimize that. ...
I have written a small HTML form and added it to the page. My goal is for it to POST the value of the Checked button to a PHP page which I have also written. The PHP page is not getting the value for some reason. I am also not getting any PHP errors. The codes are below. form.php <form action="http://www.zbrowntechnology.com/InsaneBr...
I am writing a Windows application that will connect to a Sybase database through an ODBC connection. It will dynamically create a SQL statement based off of selections by the user in the GUI. It needs to be fast (1M+ records sometimes) and have the ability to export to Excel, or some other reporting tool (graphs, etc) What would be th...
SELECT HQRH_BADGENO, HQRH_SHIFT, HQBD_BADGENAME, HQRH_DISCRRECONCILE, HQRH_ADJUSTAMOUNT, HQRH_DISCRADJUSTMENT, CASE HQRH_DISCRRECONCILE WHEN 'HQRH_DISCRRECONCILE <0' THEN 'HQRH_ADJUSTAMOUNT' WHEN 'HQRH_ADJUSTAMOUNT>0' THEN 'HQRH_ADJUSTAMOUNT' WHEN 'H...
i am working with windows form application , In that i am retrieve the data from XML and filter needed data from that, I am using for loop it made our application slow ,so i like to go with Linq, i need some tutorial and example for retrive and filter data from XML using Linq. Another question in that ,i am retrive and fliter data from d...
I've come across a couple of ORMs that recently announced they are planning to move their implementation from Active Record to Data Mapper. My knowledge of this subject is very limited. So a question for those who know better, is Data Mapper newer than Active Record? Was it around when the Active Record movement started? How do the two r...
Hi, Please help me out to execute a MySQL Stored procedure in command line, where the procedure contains conditional statements.. ...