220 Topics

Member Avatar for
Member Avatar for star_lavender

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 …

Member Avatar for Ezzaral
0
249
Member Avatar for lewashby

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 …

Member Avatar for griswolf
0
76
Member Avatar for moon207

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 { …

0
34
Member Avatar for lewashby

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.

Member Avatar for lewashby
0
162
Member Avatar for koveras vehcna

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 …

Member Avatar for koveras vehcna
0
238
Member Avatar for koveras vehcna

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 …

Member Avatar for koveras vehcna
0
350
Member Avatar for Rishikeshan

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" …

Member Avatar for pritaeas
0
149
Member Avatar for Rishikeshan

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?

0
77
Member Avatar for agent7

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 …

Member Avatar for parry_kulk
0
560
Member Avatar for agent7

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 …

Member Avatar for agent7
0
231
Member Avatar for thalz
Member Avatar for tushartyagi

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 …

0
143
Member Avatar for mihir.p

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, …

Member Avatar for ~s.o.s~
0
171
Member Avatar for fankoff

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 …

Member Avatar for bapi
0
106
Member Avatar for samarudge

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 …

Member Avatar for abhisek.sanyal
0
468
Member Avatar for tyson.crouch

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

Member Avatar for griswolf
0
125
Member Avatar for severman

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!

Member Avatar for sourcebits
0
112
Member Avatar for helios0684

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 …

Member Avatar for woooee
0
297
Member Avatar for helios0684

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 …

Member Avatar for helios0684
0
485
Member Avatar for severman

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 …

Member Avatar for Slapo
0
138
Member Avatar for jenitha

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 …

0
48
Member Avatar for cwarn23

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 …

Member Avatar for sourcebits
0
79
Member Avatar for natha

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, …

0
55
Member Avatar for sandydeb

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

Member Avatar for peter_budo
0
35
Member Avatar for khess

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] …

0
920
Member Avatar for nikhilmohan

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. …

Member Avatar for jwenting
0
209
Member Avatar for Shreerang
Member Avatar for Lala2010

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 …

Member Avatar for vegaseat
0
129
Member Avatar for andreski

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 - …

Member Avatar for Salem
0
108
Member Avatar for maleko

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 …

Member Avatar for saiprem
0
156
Member Avatar for vivek4020

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 …

0
89
Member Avatar for c_skyscraper

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 …

Member Avatar for vinodh123
0
398
Member Avatar for selimhanov

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 …

Member Avatar for Pupo
0
158
Member Avatar for mmonclair

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 …

Member Avatar for pty
0
212
Member Avatar for jakx12

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 …

Member Avatar for masijade
0
529
Member Avatar for gpss

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 …

Member Avatar for chrishea
0
105
Member Avatar for pokerDemon

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 …

Member Avatar for jbennet
0
110
Member Avatar for gpss

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 …

Member Avatar for phobia1
0
142
Member Avatar for sbmahire

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

Member Avatar for quuba
0
32
Member Avatar for fferrandini

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 …

Member Avatar for fferrandini
0
106
Member Avatar for peter_budo

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 …

Member Avatar for peter_budo
3
88
Member Avatar for gpss

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 …

Member Avatar for gpss
0
141
Member Avatar for gpss

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 …

0
63
Member Avatar for Rkeast

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 …

Member Avatar for Rkeast
0
134
Member Avatar for khess

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 …

0
97
Member Avatar for JRED

This code snippet will attempt to show newbies to php how to connect and retrieve data from a PostgreSQL Database Server using PHP.

Member Avatar for Troy
0
193
Member Avatar for jay_412

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 …

Member Avatar for jay_412
0
190
Member Avatar for nickcampbell

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 …

Member Avatar for woooee
0
2K
Member Avatar for goldy736

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 …

0
69
Member Avatar for bodikon

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 …

Member Avatar for sknake
0
114

The End.