Hi, I would like to execute some kind of subquery with my fetchedresultscontroller. I've got a set of items which have a flag like "viewed" or "not viewed". Is it possible to switch between these items... Sure I could do a complete refetch but this takes some time. Is there a better way for doing this? Many thanks! ...
what is a recordset in vba? what does it serve? how to use them? thank you for helping me ...
Hi, Is it possible to craft a wildcard WHERE query with Doctrine, like so: ->where('this_field = ?', ANYTHING); I'd be using this to build a search query dynamically out of unknown user-selected parameters and therefore would need to have the condition in place but capable of accepting the value "anything". To add, I can get this to...
I'm thinking like the methods games like Counter Sstrike, WoW etc uses. In CS you often have just like 50 ping, is there any way to send information to an online MySQL database at that speed? Currently I'm using an online PHP script which my program requests, but this is really slow, because the program first has to send headers and pos...
I've got a list of synonyms and need to create a database in SQL for it. I was thinking about using a Relational Database Design, but don't know if it would be the best. There will be a decent amount of traffic using this database. I was thinking about Table1 would be like Id Table2 Id InterlinkID (Table1 Id) Word Would this be th...
I'm using ESE (JetBlue) in an app, when JetAttachDatabase is called it returns JET_errDatabaseDirtyShutdown. What am I supposed to do in my app? my desire is for any uncommeted transactions to be deleted ...
is it possible to change a combo box to text box using vba? ...
In my project i have to give a string input through a text field, and i have to fill a database table with these values. I should first check the values of a specific table column, and add the input string only if it is not there in the table already. I tried to convert the table values to a string array, but it wasn,t possible. If any...
Hi, I need to store info about county, municipality and city in Norway in a mysql database. They are related in a hierarchical manner (a city belongs to a municipality which again belongs to a county). Is it best to store this as three different tables and reference by foreign key, or should I store them in one table and relate them w...
I have a table with hit statistics for some items in another table. This table is defined like this ID (Primary key) ItemId (Foreign key) Date Hits Giving me have a record pr. item pr day. The database is used in a multithreaded environment, so two users might make the first hit at the same time causing two records to be created, w...
Is it possible to import a single database from an --all-databases mysqldump? I guess I can modify the file manually but wondering if there are any command line options to do this. I am moving servers and have a lot of databases, most of which I don't currently need or want at the moment but would like to have the option to restore a si...
I am trying to insert some rows into a table which has a field of integers, which can be NULL: cur.execute("INSERT INTO mytable (id, priority) VALUES (%(id)d, %(priority)d)", \ {'id': id, 'priority': priority}) The priority variable is either an integer or None. This works when priority has an integer value, however, when ...
I am reading the database schema for VistaDB 4.0 database using the standard ADO.NET 'DbConnection.GetSchema' API. I haven't found a way to obtain the 'Identity' setting for a column? The 'Columns' schema collection doesn't seem to have a column for this and I am not aware of any other collection that I should look into. If it is not po...
In our database we have users: A, B, C. Each user has its own corresponding schema: A, B, C. Normally if I wanted to select from a table in one of the schemas I would have to do: select * from A.table; My question is: Is there a way to make: select * from table go to the correct schema based on the user that is logged in? ...
I'm using Vertica Database. I am trying to get the total secs in a particular hour from the following example session data. Any sample SQL code would be very helpful - Thanks start time end time session length(secs) 2010-02-21 20:30:00 2010-02-21 23:30:00 10800 2010-02-21 21:30:00 2010-02-21 22:...
I new to MySQL. I would like to copy the content of one table to another table within the same database. Basically, I would like to insert to a table from another table. Is there easy way of doing this? thanks for any help ...
I would like to begin work on an iPhone app that does little more than display a books content for reading. The book content is available online, and is fully open source, but I would like to make the content available locally. With apps that I have worked on previously, namely with iPhone OS 2.X, creating (or finding) an .sql database a...
I'm new to Rails. I had created a Rails application earlier and also collected a few data records in the development database. Suppose, I create a new Rails application and I prefer to use the existing development database of the 1st Rails application in my newly created Rails application, how do I do that? ...
Hello, for a traffic accounting system I need to store large amounts of datasets about internet packets sent through our gateway router (containing timestamp, user id, destination or source ip, number of bytes, etc.). This data has to be stored for some time, at least a few days. Easy retrieval should be possible as well. What is a go...
I want to define some Contact Groups. I am wondering where and how does Android store the groups. Maybe in a Sqlite database? If so, will be able to run a insert on it? Otherwise how do you add new Contacts Group via the emulator? ...