I am currently building an application that allows users to track where their phone has been on a Google Map. At the moment, when the onLocationChanged() method is called, the application stores the current GPS longitude and latitude in a database and calls the animateTo() method to the current position.
Using SDK 1.5, how would I go about connecting these points with a coloured line drawn on the MapView using an Overlay?.
Hi
Is there any way to massively alter primary keys(uid) to all tables with no primary primary keys in sql server database ? I have a lot of tables and most of them don not have primary keys.
Thanks in advance.
How can I call Access's Compact and Repair Database utility from within C++? I'm already using ADO and ADOX, so a solution using either of those would be handy.
I'm looking for a way to get all rows as insert statements from one specific table within a database using pg_dump in postgres.
eg I have table A and all rows in table a I need as INSERT STATEMENTS, it should also dump those staements to a file
Is this possible?
In order to save time moving data I pickled some models and dumped them to file. I then reloaded them into another database using the same exact model. The save worked fine and the objects kept their old id which is what I wanted. However, when saving new objects I run into nextval errors.
Not being very adept with postgres, I'm not sure how to fix this so I can keep old records with their existing ID while being able to continue adding new data.
Thanks,
Thomas
I would like to get a list of well-known buildings(museums, castles etc..) within X meters radius of the current coordinate. I would like to query them in PHP.
Do you know any such database that can be queried?
I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option.
any easy code options?
Thanks
newbie
Hi all
I am new to Php and working on a project which needs to generate sitemaps from URLS which stored in MySQL database. how can I do this?? Is there any one have any idea??
site maps can be in php extension too and only requirement is list of sites display in each page
I am using ListView/DataPager.
For performance reasons I page my results at database, using ROW_NUMBER(SQl2005).
At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3).
I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I prevent this?
My application is a non-relational database application with a tcl interface to retrieve data. I would like to add SQL programming interface to my application.
Is there any library that converts SQL/PLSQL statements to API calls? It should also support stored procedures.
SQLite(Embedded) has 'virtual table' mechanism that suits my requirement but it lacks stored procedure feature.
-Gopala
So I'm using the datepicker plugin to make an availability calendar. Here is my javascript:
http://pastebin.com/H7D9PcAg
When dpSetSelected() is called it is also calling dateSelected() which triggers the AJAX call to my PHP script. I need a way to only update the database if the date is clicked on and not pre-loaded. When I pre-load the dates they are sent to the PHP page and subsequently removed.
Hey all
i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused
I want to create a Rails (2.1 and 2.2) model with ActiveRecord validations, but without a database table. What is the most widely used approach? I've found some plugins that claim to offer this functionality, but many of them don't appear to be widely used or maintained. What does the community recommend I do? Right now I am leaning toward coming up with my own solution based on this blog post.
Hi all,
Somebody knows how to change the user account and authentication method sharepoint uses to connect to its content database?
It is now setup to connect using Windows Integrated Authentication but I want to change that to a local user account.
Is it even possible to do this?
Thanks in advance
I am using SQLite to store school classes. I want to fill in a Spinner with the classes that get stored in the database. How would I grab all the classes in the DB and load them into a spinner?
I have a SQL Server Express database that has a query that should return about 230 thousand rows.
Problem is the query returns about 5 more rows each time you run the query.
What would cause something like this?
I ran 'DBCC CHECKDB' but that did not change the behavior. Any ideas.
thanks
Hi,
I want to integrate the beast forums in an existing rails app, but
there is a database conflict. I already have a "post" model for the
blog and beast requires it. How do I eliminate the problem?
Regards
How would i go about creating an application for my web page that can extract data from my database (i currently get the data in a CSV file). id also like the user to be able to filter the data by certain parameters. can u help
i code some configuration setting. And need those values to be load, everytime my webapp start. yes, it's somekind autoload setting.
But, right now, i have to choose between save it as object or array. is there any different between them when we save them in database ? which one is faster or maintainable or other pro and cons
thanks
This is the query to update table in one database that is of other
Update
test.temp a,
test2.temp b
Set a.name=b.name
Where a.no=b.no;
Now I don't want to write every field i.e a.name=b.name
Is there any solution?