Search results for query: *

hi all... i used php and postgresql and FreeBSD as OS. I need suggestion for my application development tools on: 1)compiler to use ? 2)debugger to use ? 3)tester to use , except jmeter. 4)profiler to use , except apd-profiler. I found eclipse but mostly for windows so similar like eclipse...

hi guys.... How can i trigger a function base on date changes on server. examples: i have 2 tables A and B : so everyday day when the date change data will copy form table A and insert it on Table B. Besides set to run the file on crontab, how can i do it on postgresql ..In other words how...

hi all.... i'm working on form that allow user to add new row in a table..i use javascript below...it works in IE but fail in firefox.....hope u all cal help me please...? tq in advance. <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function addRow(id){ var tbody =...

hi all... I have problem when using "money" as data type when performing calculation. this data type suddenly produce -ve value. for example? 1) insert 1000000000 ..it becomes 12,157,521.92 2) insert 2000000000 ...it becomes -18,634,629.12 why after 10 character it display other value...

hi all.. can anybody suggest or show me the best way to make orgchart ...i'm using php & postgresql. i try this code ... http://www.sitepoint.com/print/hierarchical-data-database wow..it work great but i have problem in doing lines and boxes in order to display the heirichal orgchart...

hi again .... base on my previous thread i try this then when i tried update on table exam this error occured..... WARNING: plpgsql: ERROR during compile of kira near line 2 ERROR: return type mismatch in function returning tuple at or near &quot;total_marked&quot; cam someone correct it...

hi all.... this is my table : TABLE 1: exam subject |id | paper_1 |paper_2|total| gred|point ---------+---|---------+-------+-----|----+------| SF017 | 1 | 40 | TABLE 2 : gred_exam grd_id|grd_from|grd_to | grd_value |grd_point|grd_subjek 1 | 80 |...

hi all... need help urgent.... i have 2 string stored in different field. so i need to campare both string .. let say $string1 = &quot;ABCDABCD&quot;; $string2 = &quot;AAAAAAAA&quot;; i use substr to compare it but it was very slow to compare about 15000 data..so could anyone suggest...

hi..alll how to join this 2 postgress tables..? my purpose is to display every user with their roles.. i tried use this( just try an error) :- select * from pg_group inner join pg_shadow ON pg_group.grolist::text = pg_shadow.usesysid my problem is on type integer[] how to join it..? table...

hi all.. i need some idea's & suggestion how to design a good postgresql table that occupied aspect as below: 1)there are 3 types of user which are admin, academic-staff & non-academic-staff. 2)academic-staff & non-academic staff can be flexsibally set their role one bye one whether can...

is there any possibility to GRANT more than one table in one sql command. tq in advance

hi all rite now i'm seeking any example on inserting huge amount of data from a CSV format into database. i'm using php & postgresql. hope u all can suggest me somethings . tq :-)

hi all... is there any possibility in SQL command to select just the year from date format in database. As we all know the format is 2002-02-24 in the database. therefore is that any possibilitty to take for example just the year by SQL command instead of we use coding which is normal method...

I think a good security balance would be to allow local users to connect using their username without a password / with a different username & password. However i haven't figured out how to actually do this; my attempts so far at what look logical seem to fail. rite now i have create 3 diffrent...

hi all i have multiple adding form .. so in order to return the id generated by auto increment field in the previous insert query i used mysql_insert_id(); so what is it in postgresql? thank in advance..

hi all if in mysql i wrote this... $query=mysql_query(&quot;insert into table1 (name,gender) values ('$name','$gender')&quot;) or die (&quot;could not select&quot;); $profileid=mysql_insert_id(); but now i'm using postgresql so what is the similar code in postgresql especially the...

hi all... i have created [back & next button]in my html pages and when i click back the warning below occur that need me to refresh that to see the page again. How to overcome this warning ..i,m newbie...tq... Warning: Page has Expired The page you requested was created using information you...

hi all; what is this error message mean: Pg_exec() query failed ERROR : Unterminated quoted string thats all tq..

hi all; how can i change the query so that the result will only display the array with value only..? $query2 = &quot;SELECT * FROM lkp_country&quot;; $result2 = pg_exec($query2); $total2 = pg_numrows($result2); while ($row = pg_fetch_array($result2)) { $arrsu[] =...

Below is my coding: can someone help me on the array part, where i only want the x-label with value will be display. in other words if no value the x-label will not be displayed for that data. tq. <? require (&quot;../core.php&quot;); $link_id = db_connect($user_dbname)...