mobile phone database from an indian shopping web site
i m currently doing research on recommendation systems for e-commerce. i require the test data. can any body tell me where can i find the database of mobile phones and details of all brands? ...
database
Date and time in PHP pagination script - slight problems
I have an events calendar written in PHP, with the following pagination script that I obtained from a free PHP site. This is the basic script (entitled PmcPagination.php): http://pastebin.com/f7c5a4a90 (linked here for convenience, too lengthy to post in full!) It works to the extent that it shows all events - but the dates do not tall...
How would you solve this GPS/location problem and scale it? Would you use a Database? R-tree?
Suppose I have a people and their GPS coordinates: User1, 52.99, -41.0 User2, 91.44, -21.4 User3, 5.12, 24.5 ... My objective is: Given a set of coordinates, Out of all those users, find the ones within 20 meters. (how to do a SELECT statement like this?) For each of those users, get the distance. As you probably guessed, these co...
Names of businesses keyed differently by different people
I have this table tblStore with these fields storeID (autonumber) storeName locationOrBranch and this table tblPurchased with these fields purchasedID storeID (foreign key) itemDesc In the case of stores that have more than one location, there is a problem when two people inadvertently key the same store location diff...
EJB3Unit testing no-tx-datasource
Hello, I am doing tests on an ejb3-project using ejb3unit http://ejb3unit.sourceforge.net/Session-Bean.html for testing. All my Services long for @PersistenceContext (UnitName=bla). I set up the ejb3unit.properties like this: ejb3unit_jndi.1.isSessionBean=true ejb3unit_jndi.1.jndiName=ejb/MyServiceBean ejb3unit_jndi.1.className=com.comp...
View Access 2007 Database Table Contents using VB.net
I am trying to display the contents of a table from an Access 2007 Database inside a List-view Box. I am using a Combo Box to select the user I wish to see the details about: Private Sub Admin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ReadUsers() con.ConnectionString = ("Provider...
Assign Unique ID within groups of records - Start with 0 or 1
This is probably a subjective question, but I would like to know your opinion. It's somehow related to this question, but I would like to now if you would start off in databases with 0 or 1. Auto-incremental ids in sqlserver start off from 1, so my subjective opinion wouuld be to start off with 1. On the other hand, in most programming l...
Convert database from Antislaed to Drupal
whether is there a converter database from AntiSlaed to Drupal? And if not, how quickly convert the base from Antislaed to Drupal? Thank you very much. Sorry for bad English and noob-question. (: ...
db4o on shared hosting with asp.net MVC
I'm wanting to use DB4o on an asp.net MVC project i'm working on but wondering if anyone has got this working on shared hosting plan, have contacted discountasp and asked them and they said go to the forum as they were not sure if they supported it or not or any configuration that would be needed. but the forum wont let my post on becau...
Why can't I insert into MySQL?
+---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | user_id | int(11) | NO | UNI | NULL | | | utm | point | NO | ...
Message from SQL Server database to application when something changes in database
I have used triggers within a database .. like .. when record in table A is deleted then also delete the corresponding record in table B, C D .. e.c.t In SQL Server, is there a way to send message to application from database using triggers ... The scenario is ... If same application ( .exe ) is opened by 2 users and both use the sa...
Execute SQL from file in SQLAlchemy
How can I execute whole sql file into database using SQLAlchemy? There can be many different sql queries in the file including begin and commit/rollback. ...
Add non-nullable columns to an existing table in sql server?
I already have a table which consists of data. I need to alter table to add two new columns which are not null. How can i do that without loosing any existing data? NOTE: The new columns are not null fields. ...
How do I get a tableview to dynamically display information that was just selected from another tableview?
I am working on an app that displays a schedule. I have no problem displaying the lists of items. My question relates to displaying information on a new tableview that relates to the selection from the last tableview. All while not having to make several hundred tableviews (big list of info). So in short how do I tell iPhone to remem...
Best mySql management tool?
I am looking for a complete integrated mySQL management / admin tool (hopefully that can run in Linux). I need the ability to graphically model my tables and relationships (reverse/forward engineering would be great). I also need a tool with good data management options (i.e. basic crud). I have tried MySql workbench and it is great f...
Create/Write Permissions in MySQL
I am experiencing some permission problems with my SELECT ... INTO OUTFILE statement. When I log into my database and do a simple export command, eg: mysql> select * from XYZ into outfile '/home/mropa/Photos/Desktop/TEST.txt'; I get the respond: ERROR 1 (HY000): Can't create/write to file '/home/mropa/Photos/Desktop/TEST.txt' (Err...
Converting Oracle SQL Select into PosgreSQL select
I have this SQL statement: SELECT ABX.ABX_APO_NUMBER, COUNT(A1.PROCESS_MODE) AS NUM_PLANNING, COUNT(A2.PROCESS_MODE) AS NUM_SETUP, COUNT(A3.PROCESS_MODE) AS NUM_OUTPUT FROM ABX, USER_INSTANCE U, ACTIVE_PROCESS A1, ACTIVE_PROCESS A2, ACTIVE_PROCESS A3 WHERE U.ABX_APO_NUMBER (+) = ABX.ABX_APO_NUMBER AND A...
Counting sentences: Database (like h2) vs. Lucene vs. ?
Hi all, I am doing some linguistic research that depends on being able to query a corpus of 100 million sentences. The information I need from that corpus is along the lines: how many sentences had "john" as first word, "went" as second word and "hospital" as the fifth word...etc So I just need the count and don't need to actually retri...
Converting from Oracle Join to Postgres Join
I have two select statements that I am trying to port from Oracle to Postgres: 1) (Note: this is a subselect part of a bigger select) SELECT 'Y' FROM CRAFT MA, CONFIG MAC, ARMS SM WHERE MCI.MS_INVENTORY_NUMBER = SM.MS_INVENTORY_NUMBER (+) AND MCI.AB_BASE_ID = MA.AB_BASE_ID_LAUNCH AND SM.ACT_AC_TYPE = MAC.ACT_AC_TYPE AND SM.MAC_ID = M...
Connecting to a Online MySQL Database using VB.Net
I've searched around and haven't been able to find anything along the lines of doing this. ...