Is there a pear mail queue reporting script that builds pretty charts and graphs from your MQ database? I have MQ set up on a cron job and I want to tie some reporting into my admin console.
Hai,
I have a radio button list control with open,close as list items.I have two columns in my database as Start Bid and End bid both the columns are datetime datatype.If i select the open list items and click search button it should show only bids that are open else viceversa.
Please suggest me with example.
Regards
Basanth
I want to somehow round the numbers for a rating system in php like this:
4.6667 = 4.6
5.0001 = 5.1
is there any way to do that? (BTW i read the datas from a database)
Im using c# windows form application. I have a database with many tables. Each table has several columns. I need to populate the combo box with the column names for a selected table.
I use decodeURIComponent and encodeURIComponent in Javascript.
Before I store this data in a UTF-8-PostgreSQL-Database, I should decode them:
$my_data = pg_escape_string(utf8_encode($_POST['my_data']));
I'm looking for a PostgreSQL-Function to convert Javascript-Encoded Data.
I have project Image Gallery website.(I use Eclipse,WAMP)
How to Connecting GWT(front end) with PHP(back end) so that GWT widget can display my database? Please give detail simple example if anyone can.
I am creating a multilingual site that will need to support at minimum five different languages, including Korean and Chinese. The site language is ColdFusion, so Java is the native language. I want to make the site as easy as possible for the next programmer to update, and for third-party translators to use tools that will work easier for them than digging through a SQL database.
So far I have come across Resource Bundles, GNU's GetText, and TMX.
Which do you recommend and why?
So I need to encode an array in PHP and store it in plain text in MySQL database, my question is should I use serialize() or json_encode()? What are the advantages and disadvantages of each of them?
I think either of them would do in this situation. But which one would you prefer and why? If it is for something other than an array?
i am connect to a mysql database using this example:
http://bitdaddys.com/MySQL-ConnectorNet.html
at the top the instruction is to:
Next add reference to: MySql.Data
how do i do that?
i populate uipicker's datasource from array built with sqlite database stored data. everythiongs works fine.. for a little while. after 6-7 spinnings, the picker freeze, and I get EXC_BAD_ACCESS. debugger indicates the program stopped in the main () function.
so, how could this happen? working for a while, and then, suddenly exit like that?
thanks
I'm in the process of implementing an ultra-light MVC framework in PHP. It seems to be a common opinion that the loading of data from a database, file etc. should be independent of the Model, and I agree. What I'm unsure of is the best way to link this "data layer" into MVC.
Datastore interacts with Model
//controller
public function update()
{
$model = $this->loadModel('foo');
$data = $this->loadDataStore('foo', $model);
$data->loadBar(9); //loads data and populates Model
$model->setBar('bar');
$data->save(); //reads data from Model and saves
}
Controller mediates between Model and Datastore
Seems a bit verbose and requires the model to know that a datastore exists.
//controller
public function update()
{
$model = $this->loadModel('foo');
$data = $this->loadDataStore('foo');
$model->setDataStore($data);
$model->getDataStore->loadBar(9); //loads data and populates Model
$model->setBar('bar');
$model->getDataStore->save(); //reads data from Model and saves
}
Datastore extends Model
What happens if we want to save a Model extending a database datastore to a flatfile datastore?
//controller
public function update()
{
$model = $this->loadHybrid('foo'); //get_class == Datastore_Database
$model->loadBar(9); //loads data and populates
$model->setBar('bar');
$model->save(); //saves
}
Model extends datastore
This allows for Model portability, but it seems wrong to extend like this. Further, the datastore cannot make use of any of the Model's methods.
//controller extends model
public function update()
{
$model = $this->loadHybrid('foo'); //get_class == Model
$model->loadBar(9); //loads data and populates
$model->setBar('bar');
$model->save(); //saves
}
EDIT: Model communicates with DAO
//model
public function __construct($dao)
{
$this->dao = $dao;
}
//model
public function setBar($bar)
{
//a bunch of business logic goes here
$this->dao->setBar($bar);
}
//controller
public function update()
{
$model = $this->loadModel('foo');
$model->setBar('baz');
$model->save();
}
Any input on the "best" option - or alternative - is most appreciated.
Hi everyone,
I'm following the Agile RoR book somewhat to apply it to a project for school. It's going good until I get to sessions. I continually get Authenticity Invalid Tokens and when I look at my sessions table in the database, there's a new session being created every time I refresh the page. Is that right or is something messed up?
Thanks.
Does anyone knows how to force WEBrick to process more than one request at a time? I'm using some Ajax on my page for long running database-related tasks and I can clearly see the requests are being processed in a pipeline.
Hiii....
I am developing small spring application. I have to store the details of the student information in the database. I have develop one simpleformcontroller.
I have used netbeans + hibernate mapping + spring. when I submit the form, jsp page is redirect on the same page and control does not go to Formcontroller..
I need to create database for SQL Server, what kind of naming convention I sohuld use?
1) Table names could be : customer, Customer, CUSTOMER
2) Field names could be : customer_id, CustomerId, CustomerID, CUSTOMER_ID, customerid, CUSTOMERID and so on...
Is there any official suggestion for naming conventions or what is msot common way to name tables and fields?
Hey!
I am planning on developing an iPhone App for a website, powered by Wordpress.
Where can/should I start codewise when developing an app for such sites? Does Wordpress have an API, should I access the (MySQL) database directly, etc?
Thank you.
I'm somewhat new to grails (not groovy though) and I'm working on a sample CRUD application. The issue I'm trying to solve is how to set a property on a bean based on a radio button before I update it in the database. Is the Form Helper http://www.grails.org/plugin/form-helper plugin the way to go? Will the bean have its value set regardless of if the button is actually clicked by the user or if it is left at its default value?
thanks,
Jeff
I have the path to a Word document saved in an SQL Database.
I am able to retrieve the path but I cannot work out the best approach to open the Word document from WPF without using the OpenFileDialog. I've given up any thoughts of embedding Word in WPF as it has too many gotchas.
I just want to be able to click a button or hyperlink and using the retrieved document path, open Word.
i have added another input parameter to a stored proc used by a crystal report. i've had our dba recompile the stp to be sure that the new parameter is cached and "really there".
i cannot get my crystal report to recognize the new parameter -- i've tried verifying database and using the Set Datasource Location/Update to re-select the stp.
i'm using cr11 against a 2005 sql server db.
any other suggestions?
For some reason, trying to view any node of a certain content type leads to a 404 error. When viewed in a View table, they display just fine. What could be happening?
Viewing the database with phpMyAdmin shows the data just fine.
The problematic node type was created with CCK.
Hi,
I have a table in an Access 2007 database, all fields are of type text. Can the following be done using the where clause. If so how?
SELECT * from Table1 WHERE (ColumnDate is between 26th and 19th of march 2010)
SELECT * from Table1 WHERE (ColumnAge is between 25 and 40)
The usual < <= operators dont seem to work.
Thanks,
Title pretty much says it.
I want to store a C#.NET ulong into a T-SQL database. I don't see any provisions for doing this, as the SQL bigint has the same Min/Max values as a normal long.
Is there any way I can do this? Or is catching an OverflowException my only hope?
I want to find out which tables have been modified in the last hour in a MySQL database. How can I do this?
I am new to MySQL so please try to explain it as simply as you can.
thank you!
in mysql database context, what is the difference among these 3 terms?
stored procedure,stored routine,stored function.
p.s. build-in functions like those date time functions, (weekday()) are considered as what?
thanks in advance!
I know that one way is to have a table in database with all the states and then you would read it in your form. Is there any easier way in your opinion guys ?
I feel bad asking for something like this since it is so elementary however I would suppose something as simple like this would already be implemented in Drupal.