11 Topics
| |
I have the query below: $insert2query="INSERT INTO output_search(ref_code, title, author, channel_id) VALUES (select refcode,title, authors, $idquery as cid from chemoJ where title LIKE '%$search%' and refcode NOT IN (select exc_refid_fk FROM exclusions))"; It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the … | |
Hi All First post. PHP/PostgreSQL newbie... I'm trying to create a simple web page with a dropdown menu. The values for the dropdown menu are retrieved from a database table. The code I've got is... <html> <body> <select> <?php $db = pg_connect("host=hostname port=5432 dbname=dbname user=user password=password") or die ("Could not … | |
I made this code: INSERT into author(authorfirstname1, authorlastname1,authorfirstname2, authorlastname2) select '".addslashes($_POST['authorfirstname1'])."','".addslashes($_POST['authorlastname1'])."','".addslashes($_POST['authorfirstname2'])."','".addslashes($_POST['authorlastname2'])."' from author where not exists(select authorfirstname1, authorlastname1, authorfirstname2, authorlastname2 from author where author.authorfirstname1='".addslashes($_POST['authorfirstname1'])."' and author.authorlastname1='".addslashes($_POST['authorlastname1'])."' and author.authorfirstname2='".addslashes($_POST['authorfirstname2'])."' and author.authorlastname2='".addslashes($_POST['authorlastname2'])."' ); The point of this code should be that it checks, if a value allready exists in database and if … | |
Good day I’m new with JSP, here the problem, I just converting the code from SQL to PostgreSQL, but a problem occur after I change to DataSource ds = (DataSource)envCtx.lookup( "jdbc/postgres" ); and add a scheme to the query. By theory it should be ok but it produce this error … | |
Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … | |
I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … | |
Hello friends, I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server. - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log - The Server version in 9.0.4 - The application is developed in C Sharp * The basic utility after Parse the Log is … | |
I'm trying to connect a DB from Postgres with a program in Java. I'm including this code: Class.forName(driver); Connection con = DriverManager.getConnection(connectString, user , password); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM students"); But I'm getting this erros in Statemen and stmt.excuteQuery: With Statement: *incompatible types. Required: … | |
I have run into an interesting problem. I have inherited a database for daemon process that polls and accepts reports from remote embedded systems. Each site that has one of these systems can monitor over a dozen different fuel tanks. (In practice, most monitor 2, 3 or 4 tanks.) When … | |
am trying to connect a jsp page to a postgress database i have created a jdbcconnects.java file and compiled it with jsp_api.jar from my apache..../lib directory i have placed the class file in root/WEB-INF/classes folder the code of my class file is [CODE] import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public … | |
Hi all, I was wondering if any of you have had any experience with Catalyst and Moose. I am starting a project that I think would use both. I plan to use mod_perl or fast_cgi with Catalyst as the framework and Mason as the template language (I have used Mason … |
The End.