220 Topics
![]() | |
hi..I am really new in Java software development..I am trying to make sure that the JXTable will refresh or update the data after the save button is clicked which means that the JXTable will display the lastest data that retrieved from the database..as what I had googled through the methods … | |
I'M reading the book "Simply SQL" and I need to use the files for the book. It was suggested to be to use postgreSQL and now I've got it up and running on my Ubuntu machine. But I'M having a little bit of trouble getting started. When I first start … | |
hello everybody, I'm new to jsp.I have to develope web portal for my company but i had problem with my login page. I hope that you can help this problem. Here is the code: <%@ page contentType="text/html" import="java.sql.*, java.util.Date, java.io.*" %> <%! String CheckLogin(String Login, String Password) throws Exception { … | |
I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies. | |
Hello everyone, I am currently creating a small JS app. that will help me search PostgreSQL and print related data via PHP. I am using jQuery to help me but I have this small problem. I wanted to test if the code worked, by prompting the PHP file to print … | |
Hello everyone, I am trying to retrieve some data from PostgreSQL using jQuery and PHP. I should be able to enter a date as input -e.g, as 2010-08-09 and retrieve all the data that is dated August 9th- however, when I execute my javascript, all I get as an output … | |
I am getting so much errors in php. I couldn't understand why. I re-checked all code but I am getting strange errors. The code below is provided to you under mit/x11 license for modification and distribution. ALL DERIVATIVES ARE WELCOME! :) Here is the code: [code=php] <html><head><link href="style.css" rel="stylesheet" type="text/css" … | |
Anyone installed miachat on postgres? I changed the config to postgres7 but it did not work. Is there any non-copyleft chat scripts for php? | |
please help with my connection i'm getting error("exception: org.postgresql.util.PSQLException: The connection attempt failed.The connection attempt failed.") this is my code.. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %> <%@ page language="java" import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML … | |
please help with my connection i'm getting error("exception: org.postgresql.util.PSQLException: The connection attempt failed.The connection attempt failed.") this is my code.. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %> <%@ page language="java" import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML … | |
somebody help me how to open connection postgresql with vb.net .. | |
There are 2 questions that I have. After banging my head with mysql server for more than 4 hours, I've given up. The mysql server will start mysql service on windows 7, but will not start another service. (Is this somehow related to admin rights of 7. I am an … | |
We are planning to make a commercial GUI based software (for both desktop and mobile) targeting individual users. We plan to have good web 2.0 like rich application features (Google like dynamic auto suggest, drag and drop, browser based look and feel etc) and lot of user controls (trees, grids, … | |
How could I like programming ? When you spend 2 days on one single, pointless line and the only thing you get to see is an ERROR-response. It`s really inhuman and I cant imagine who would want this voluntarily. Nevertheless, what am I yammering about is following error, that is … | |
Hey, I need to install PHPIze (To install XCache) so I ran the command [CODE]yum install php-devel[/CODE] (PHPIze is within the php-devel package) And that gives me the output [CODE]Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * epel: ftp.uni-koeln.de * rpmforge: ftp-stud.fht-esslingen.de Setting up Install Process Resolving Dependencies … | |
G'day, Just a simple question. Does MySQL Support Inheritance? I understand that both Oracle and PostgreSQL support Inheritance, but haven't seen anything in MySQL regarding this. Regards, TC | |
hi all does anybody here knows a good safe way to work with sql stored function with zend framework? i can do so with prepared statement but i'm sure that there is safer way to do so... i'm using postgreSql but i don't think that there's any different. thanks! | |
Alright, let's try this again. I've started over from scratch and we have got the basic functions working. Everything so far has checked out, but I am still trying to get it to pull the right credentials. I can get it to pull one of the rows out of the … | |
Hey, I need help with setting up an authentication code. I am currently working on a project to build a blog server in python for an intro level python course. We are using the PESTO and POSTGRESQL wsgi and sql clients respectively. I am trying to authenticate against a user … | |
Hi all I'm new to PostgreSql i'm trying to write a simple function [code] CREATE OR REPLACE FUNCTION insert_tmp_pswd2 (int4, varchar) RETURNS int4 AS ' DECLARE tmp VARCHAR; BEGIN insert into "ExAfrica".test2 values($1, $2,now());select 1; END; ' LANGUAGE 'sql'; [/code] i really dont know why he doesnt want to declare … | |
hi, i want to insert the values into the postgresql database using jsp code.first i have to retreive the values from one table which will be displaying in combo box.And i have to store it in another table which is having the auto increment data. hope u understand.... can anyone … | |
Hi, I have a script which is meant to use all of my servers cpu but mysql will only use one core. I have 8 cores but only 1 core is being used. Does anybody know how to allow mysql to use multiple cores? -------- Second question How do I … | |
Please forgive the long post, but I thought it best to be thorough, even if I'm only looking for pointers. I am working on a schema for a PostGreSQL dbase that is meant to contain all the metadata for all our Digital assets that are for distribution on online: audio, … | |
Hi All, I am supervising a project on JSP. The problem is JSP is not compiling in IE6, the coding environment is running through NetBeans. The version of the browser is as per project requirement. FYI- the DB is PostGreSQL. Please help me | |
Florian Mueller, Open Source Patent Activist, just released the following information. He believes that patents already used by IBM against [URL="http://www.turbohercules.com"]TurboHercules[/URL] are also a threat to other major FOSS projects. He now calls on the community for action. [URL="http://openbsd.org"]OpenBSD[/URL], [URL="http://xen.org"]Xen[/URL], [URL="http://virtualbox.org"]VirtualBox[/URL], [URL="http://redhat.com"]Red Hat Enterprise Virtualization[/URL], [URL="http://mysql.com"]MySQL[/URL], [URL="http://postgresql.com"]PostgreSQL[/URL], [URL="http://sqlite.org"]SQLite[/URL] and [URL="http://kaffe.org"]Kaffe[/URL] … | |
can anyone help me to backup/restore my database file by using jsp code??? im using postgres sql... please its urgnt..tnx in adv. i am using fedora 11 i got this code from an article. but i know it will not wrk.. pls help me if any one hav any idea. … | |
Hey all, How can we create a new PostgreSQL database using a shell script? | |
I have written a Python program that takes information from the user at the command line, and then saves this data in a PostgreSQL database. Now I want to wrap a GUI around my program. I am just starting with wxPython and have completed a few tutorials, but still can't … | |
Hi: Among the following technologies what you consider is the best tool for a developer to achieve more and best payed works? php - css - wordpress - .NET - ActionScript - ajax - android - asterisk - C# - c++ - css - Delphi - drupal - flash - … | |
I have a postgresql view on which I'm running the following query : [CODE]select count(*) AS "Assigned Calls" ,to_timestamp(createdon)::date from vw_issues where to_timestamp(createdon)::date>='11/10/2009' and to_timestamp(createdon)::date<'11/11/2009' group by to_timestamp(createdon)::date order by to_timestamp(createdon)::date[/CODE] when run in phppgadmin the result is displayed as Assigned Calls to_timestamp 20 2009-10-12 13 2009-10-13 etc... I need … | |
Hi I am just learning Java DB Database in NetBeans IDE 6.8 I am following this tutorial [url]http://netbeans.org/kb/docs/java/gui-db.html[/url] The first problem is when creating the database and adding a table to it I was able to create the car_database but when i connected it and expanded the node its not … | |
Hello Guys; I’m studying computer science on my third year. we are asked to develop a project based on data warehousing and business intelligence, using java language and postgresql. the main thing that is expected from us, to create fact and dimension tables from existing tables and then fire simple … | |
Hi, It must be a simple issue, but couldn't find any answer googling. Here is the problem: I have a simple test application with a TextCtrl, Button and StaticText. When I press the Button, it must query PostgreSQL with ...[code]SELECT name FROM contacts WHERE name LIKE '%"+TextCtrl.Value+"%'[/code] and return the … | |
Hi all, I am having a bit of an issue with a table I added (we'll call it 'new_table', with primary key 'key_id') to a PostgreSQL database I am working on. I recently created a table whose primary key is a serial int4. I have a standard query I run … | |
Ok so what i want to be able to do is connect to a mysql database. Here's my code so far: [CODE] Connection connection = null; try { // Load the JDBC driver String driverName = "postgresql-8.4-701.jdbc4.jar"; // MySQL MM JDBC driver Class.forName(driverName); // Create a connection to the database … | |
Hi! I need help... i want to make a button that when i click on it... it save's some attributes of my database (postgreSQL), and it save in .xls or .txt file... how can i make that? is it possible?? i can show my attributes on a table view on … | |
Ok so heres my story. Ive done basic programming before with serverside javascript which is not really used but effective when creating small backend databases and its kinda like vb script, so im familiar with basic concepts like funtions, arrays etc Ive been reading some books on C++ and ive … | |
Hi! I need some help... i searched a lot.. but dind't found or worked any code.. so i need help please.. i just need a simple thing... i want to show on a combobox, a list of the things that i have (inserted before on my database-postgreSQL) on a collumn … | |
hi friend i wish to store mp3 files in postgresql database i want to store this for my project i am using java as front end and mp3 files as backend | |
Hi guys. im new in this forum, getting used to python+turbogears and already have a doubt. i have a sql statement to do , that uses "like" . for example: sql = db.text("select name from users where name like '%Fernando%' and dt_birthday='%s'" %(dt_birthday)) and the server gives me the following … | |
I would like to know if people would be interested in participating building similar starting thread like we have in Java section [URL="http://www.daniweb.com/forums/thread99132.html"]Starting "Java" [Java tutorials / resources / faq][/URL], but targeting Java web development. This thread would hold resources (where to get the things, configurations, basic usage and any … | |
Hello! I need help.. please.. i'm new at php... but i need to make this: i have a database (postgreSQL) on a server... now on my webpage, i want to insert (manually-in my webpage) like with a text box, i insert there the client name (and other box's for the … | |
Hi! I need a great favor... if someone could help i really appreciate... heres the deal: i made one year ago a webpage with a database on isQL*plus ([B]pl/sql[/B]) language.. on my webpage i have this (i will show images to you understand better what i mean): [URL="http://img36.imageshack.us/img36/5783/gerirjogadores.jpg"]http://img36.imageshack.us/img36/5783/gerirjogadores.jpg[/URL] code: [CODE]procedure … | |
![]() | Sorry for posting this in this forum, but there is no forum for PostGreSQL. I am currently attempting to optimize a function that uses up to 3 seperate SELECT queries, by using a CASE conditional in my query. Right now my function does an initial query, then if no results … ![]() |
Yet another victory in the open source vs. all takers (well, one taker for sure) battle for world dominance--London's Oyster system is now Linux-powered. Oyster is a RFID (Radio frequency identification) card recognition and payment system for London's Tube (Subway) and bus network. The old system needed a serious upgrade … | |
This code snippet will attempt to show newbies to php how to connect and retrieve data from a PostgreSQL Database Server using PHP. | |
Im having trouble to use this function FillList ($sql, $selected=0) from my Mysql Class.. I want to implement it to a dropdown box in my page this is the full MysqlClass.php <?php // Read the database name for the site //PostgreSQL-PHP include "mysqldb.php"; class MySqlClass { //this are the global … | |
Hi, I've got two tables in a database - one a list of schools (around 50 entries), and one a list of pupils (around 17,000). Both are spatially-attributed using PostGIS. Basically I need to allocate each pupil to their nearest school. Currently I'm looping through the schools repeatedly, using the … | |
hi , i just started working in python , am using postgresql connected using turbo gears , python . I have connected to DB modifying the dev.py , I want to display a created table from postgre sql in web browser using python turbo gears , my table in the … | |
Feeling a little bad, two questions from you guys in a week! So I am about to embark on a project including Point of Sale, Inventory Management, Client management, (quite in depth). The difference is any information regarding Clients will be stored locally throughout the day and then uploaded to … |
The End.