I am trying to create a website using Symfony and PostgreSQL. I cant find any documentation that shows how to do this. All the documentation assumes the backend db is mySQL.
Anyone knows how to do this?
I have a PHP application that I want to switch from MySQL to Cache DB. I was wondering if I could somehow use a JDBC or ODBC connection since Cache doesn't come with a PHP connection?
Thanks
Can somebody tell me, why does Linq to Entities translate many to 1 relationships to left outer joins instead of inner joins? It relation was many to 0..1. There's referential constraint on DB itself, that ensures there's a record in the right table, so inner join should be used instead.
Is it possible to write LINQ in a way so they will translate to inner joins rather than left outer joins. It would speed query execution a lot.
Hi guys.
I've accidentally dropped a database inside my server .
I have no backup of it and binary logs are not enabled (shame on me!) ...
Is there any way to restore that db?
We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too.
It should be easy to switch the db vendor by some setting in a config file.
Is this possible? I prefer real life examples!
What kind of providers did you use?
If I have a query that returns a DateTime, what's the value of FirstOrDefault? Is there a generic way to get the default value of a C# scalar? Example:
var list = (from item in db.Items
where item.ID==1234
select item.StartDate).FirstOrDefault();
Edit: Assume that the column StartDate can't be null.
In the article Using Java DB in Desktop Applications the Address Book demo have a method disconnect which have a try-catch block that catch and ignores the exception. If you add a printStackTrace you can see that the exception always occur.
What's wrong here? The JavaDB should not throw this exception, or they should fix something in the example program?
I have an online gateway which requires an HTML form to be submitted with hidden fields. I need to do this via a PHP script without any HTML forms (I have the data for the hidden fields in a DB)
To do this sending data via GET:
header('Location: http://www.provider.com/process.jsp?id=12345&name=John');
And to do this sending data via POST?
Hi all,
I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p?
The db is on sql 2005.
Any help would be great.
Hi, I have a PHP form (mortgage app) that is about 400 fields, traffic on the site will be low.
What is the ideal Session size for 400 fields going into a MySQL db?
In PHP.ini what do I set?
Anything I should set that I am missing?
-Jason
I have a string in my db I want to pull into my page and convert to a json object.
[
{id: 1,title: "Long Event",
start: new Date(2009, 5, 6, 14, 0),end: new Date(2009, 5, 11)},
{id: 2,title: "Repeating Event",
start: new Date(2009, 5, 2)},
{id: 3,title: "Meeting",
start: new Date(2009, 5, 20, 9, 0)},
{id: 4,title: "Click for Facebook",
start: new Date(2009, 5, 27, 16),end: new Date(2009, 5, 29),
url: "http://facebook.com/"}
]
How can I do this using JQuery?
public class BaseClass{
public static T Find<T>(object value){
-- db.get<T>("params", value);
}
}
public class Derived: BaseClass{
}
...
void someMethod(){
Derived obj = Derived.Find<Derived>(1);
}
In the above code how do I change Derived obj = Derived.FindDerived<Derived>(1); to Derived obj = Derived.Find(1);
This is the connection string that is currently working on a non-password protected MS Access database.
db.url = jdbc:odbc:Driver\={Microsoft Access Driver (*.mdb)}Dbq\=C:\Inventory.mdb;DriverID\=22;READONLY\=true
How do I add a password to this connection string?
Thanks!
I have a list of artists, albums and tracks that I want to sort using the first letter of their respective name. The issue arrives when I want to ignore "The ", "A ", "An " and other various non-alphanumeric characters (Talking to you "Weird Al" Yankovic and [dialog]). Django has a nice start '^(An?|The) +' but I want to ignore those and a few others of my choice.
I am doing this in Django, using a MySQL db with utf8_bin collation.
I have PL/SQL function, which is programmed to sort a set of data. This function work fine without any error, when called directly as a PL/SQL Function.
However, when I call this Function Via a Unix Shell Script, even though the script returns a success code and throws an Out Process Memory Error and function is actually not executed.
I have verified the DB Index spaces and temp spaces, which are more than 50% free spaces
Hi,
In a WPF app, in MVP app
I have a combo box,for which I display the data fetched from Database. Before the items added to the Combo box, I want to display the default text such as " -- Select Team --" , so that on pageload it displays and on selecting it the text should be cleared and the items should be displayed.
Selecting data from DB is happening. I need to display the default text until the user selects an item from combo box.
Please guide me
Thanks
Ramm
May be this simple. But, I've hard time figuring it out.
I've a controller with different actions that calls the DB code and return result. I want to pass the value of text box to different actions in controller.
How to do it? I know that, I can pass values by using form. But, I don't to know how to call different actions in controller from single view.
On Wordpress, I keep getting irrelevant search results.
Some search strings that do not exist on the DB yield All Posts as results.
Some search strings that DO exist, works great.
What could be the cause of that behavior? I've uninstalled all related plugins. Is there a way to debug the search?
Thanks!
I have a raw sql query I need to run, but the database name changes in each environment (live: db, dev db_test)
I need to get the current database name from the databases.yml file.
How can I get just the current database name?
I am using the Propel ORM
Hi, i want to have pre-made list of most common OSes in my DB and all non default to be listed as other. Problem is i don't know what OSes called in Request.Browser object.
List i want to have WinXP, Vista, Win7, Linux, MacOS and other...
Do any of you know what are exact names of these OSes in Request.Browser.Platform or where i can get list of values from ?
the question is rather simple but I couldn't find a precise answer:
in a myisam db, what happens if a php file locks a table (with an atomic operation, say an INSERT) and another php file tries to access the same table (reading or writing)?
Now, while it is obvious that the second session will not be able to access the table, what exactly happens? Does it return some kind of error? Does is wait in queue until it is able to access it?
Thanks in advance!
I want to sell my application, but I wonder is there any cheap/free cms or script to validate the paypal transaction, and then send serial from a db to desired email?
I'm quite new to Quartz and now I need to schedule some jobs in Spring Web App.
I know about Spring + Quartz integration (I'm using Spring v 3.1.1) but I'm wondering if it's the right way to follow.
In particular I need to persist my scheduled tasks in a DB so I can re-initialize them when application is restarted.
Are there some utilities provided by Spring scheduling wrapper to do this?
Can you suggest me some "well known" approach to follow?
Does the calendar application in Android maintain a cache of its database?
Whenever I edit and mark some events via the calendar app, it is stored in the database but if I edit the calendar.db from some outside source the changes made are not reflected in the calendar app. So my question is:
Does the calendar app maintain a cache or some other form of database?
If yes then where and how?
How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)?
The dump should be in SQL format, as it should be easily re-entered into the database latter and should be done from the command line. Something like
sqlite3 db .dump
but without dumping the schema and selecting which tables to dump.