I want to convert the db with innodb tables into myisam, all of them. How can I do these? there are some foreign keys exist among tables.
how can I make this in the best way?
Hi All,
Could I get ideas on retrieving the dataset using lookup method. Basically, my scenario as I have source data needs to lookup for other source table and on matching column from source I need to get all the records from other source data.
its a one to many relations. I tried Lookup but gives only one record on matching condition, OLE DB command don't retrieve any data as it will do only Insert/Update operations.
Thanks
prav
Hi,
I'm starting learning Ruby on Rails. So my application, like every Rails app, has three databases:
Development
Test
Production
And the question is: how do i switch from a db to another?
Thanks
I would like to create an application from a database schema using seam-gen, unfortunatly informix isn't supported out of the box.
Where can I add another db?
Hi,
i have an strange problem. I want to select "timestamps" from an DB Table with Distinct and orderded by timestamp.
ID TimeStamp
-- ---------
1 123456789
2 123456789
3 333333333
4 334345643
In my PHP Script:
$sql = "SELECT DISTINCT TIMESTAMP FROM TIMESTAMPS ORDER BY TIMESTAMP"
When i use order by, the values are returned twice? Without order by the
result is correct.. but not sorted.
We are using Oracle 10g
Any ideaS?
Is it possible to override methids for db.Model in Google App Engine?
I want to declare beforeSave, afterSave methods, etc.. to create automatic tagging system.
I know there are hooks, but it seems to me a wrong way to solve this issue :)
Thanks!
I'm really looking for something very similar to the way SO is setup where a few different kinds of things can be voted on (questions AND answers). What kind of DB schema, generally, could I use to support voting on many different kinds of objects?
Would I have a single Vote table that would have references to other objects in the database? Or do I have to have or should have a separate vote table for each of the objects I would like to vote on.
I want this SQL query to be written in rails controller using find
select id,name from questions where id not in (select question_id from levels_questions where level_id=15)
How will I do this?I am using Rails framework and MySQL db
thanks in advance.
Hi
I am using two different databases for my project.
Oracle and apache derby and trying to use as much as possible ansi sql syntax supported by both of the databases.
I have a table with column amount_paid NUMERIC(26,2), in a table.
My old code which was using oracle db need to retrieve value in this format
SELECT LTRIM(TO_CHAR(amount_paid,'9,999,999,999,999.99')) .
How can i do this using ANSI sql syntax.
In MongoDB, I have a document with a field called "ClockInTime" that was imported from CSV as a string.
What does an appropriate db.ClockTime.update() statement look like to convert these text based values to a date datatype?
to create new a new databse file start sql server management studio express on db server and create it!
i would like to create a database using c# in my web application visual studio 08
is it possible?
as connection string has to have a name of database to connect, but i want to create one.
Hi There,
we have a requirement to develop a webapp ,using C# in bussiness layer, sql server as DB,
and Flex as the UI . given this i want to know tips,tricks and pitfalls .
mainly WRT Design and deployment.
Thanks in Advance.
Deepak
I have some data in db,now i m making them to display in the front end so,i ii have a update button,if i click it the selected values to come to database
http://dpaste.com/hold/180761/
Thnx in advance.
Hi all, i have searched Google and also searched Stack Overflow to no avail.
I am looking for a PHP / MySQL driven dynamic image slideshow. One similar to 'lightcyclers.com', i have information stored in the DB and i just want to display random or popular content etc.
I am also not interested in coding one myself as i am busy working on other features.
Any links or help would be much appreciated.
Ok, So I have to generate very complex reports from my DB.
If I am to do it with SQL the query themselves will be complex, and I will have to do some more manipulation on the results later, code level.
How do libraries like Jasper Reports/ Crystal Reports and friends save me time when developing such reports?
What will they give me?
I am taking a text file from user and then posting that file back to the browser using ajax storing the content in db and then showing the content back to user page using Jquery post response.
Now i want to something like this..
Read the text file from the user computer using javascript. Display the content and when he submits the page I will save the values.
So, MongoDB defaults to "AND" when finding records. For example:
db.users.find({age: {'$gte': 30}, {'$lte': 40}});
The above query finds users = 30 AND <= 40 years old.
How would I find users <= 30 OR = 40 years old?
Hi I am trying to make a simple search form that uses a startTime and endTime to specify a time range. The db has a datetime field time that is compared against.
So far when i try to use params[:startTime] in the controller I get an array of values which wont work with :conditions = ['time < ?', params[:endTime]]
Is there a simple solution to parse the form's datetime to SQL datetime?
is there an activerecord (any similar SQL-wrapper) for python? which is good for:
used in a server-side python script
light-weight
supports MySQL
what I need to do:
insert (filename, file size, file md5, the file itself) into (string, int, string, BLOB) columns
if the same file (checksum + filename) does not exist in db
thx
Hi,
Is it possible for entering values into dropdown and saving that values to DB? If yes please help me by giving the code for that. Thanks in advance
Could anyone help me please in JQuery?
I have two tables on my site leftTable and rightTable with same column names. The leftTable I fill up from a DB, but the rightTable it just contains some rows. What I would like to do is to not show (or remove) in the leftTable those rows which are exist in the rightTable!
I Tryed this:
$("#tableLeft tr").each(function ()
{if ($(this).find("td")[0].innerHTML == $("#tableRight tr").find("td")[0].innerHTML) {$(this).remove;}});
I want to use a database which name is stored in a variable. How do I do this?
I first thought this would work but it doesn't:
exec('use '+@db)
That will not change database context
Suggestions anyone?
Hi,
I have a method which handles a set of records.This method,return true\false after processing.So,if all the records are processed(doing some db updates),will return true.Now,suppose after processing 1 record,some exception is thrown,should I write result=false(at the end of method result is returned) in catch block? And,allow processing of other records to be done?
If one has three fields in a db that they are querying an object by....
One of these fields must always be an associations id.
Concerning the other two fields "only one needs to be true"
What interpretation do you take or make of "only one needs to be true"?
I would like to set some values in the node before actually writing the data to the DB. I already have it working by modifying book_nodeapi but I would like to do it from outside the code, some _alter option that allows me to leave the module code untouched would be great.
Thanks