Search results for query: *

hi all... tq for all your response... yes dreamweaver is very good.....and i used it and still use it..but now i plan to use teh opensource pakage tools.. what i found now is Gubed - debuger Quanta - editor almost like dreamweaver profiler - not found...

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 ..tq for replying.... yes this code actually work in fireforx tq guys.. typo in "t" in <tbody>...at my actual code.. it will not work when we put it like this: td1.appendChild(document.createTextNode("<input name=\"start_date1\" type=\"text\" size=\"7\" >")) because of the property...

hi all... i'm a beginner .... i try it on firefox browser.. it does not work...why?

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

continue ... machine=# INSERT INTO money VALUES ('1000000000'); INSERT 107451 1 machine=# INSERT INTO money VALUES ('2000000000'); INSERT 107452 1 machine=# SELECT * from money; price ----------------- $12,157,521.92 -$18,634,629.12 (2 rows)

1st of all tq.... my version : select version(); version ------------------------------------------------------------------------------------------------ PostgreSQL 7.3.9 on i386-portbld-freebsd5.4, compiled by GCC cc (GCC) 3.4.2 [FreeBSD] 20040728...

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

mmmm... first of all thankss... can you point me to any examples that apply the use of GRANT table in php-postgresql in controling the user right..thats all tq

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

mmm guys i got the solution already... but i wanna to check is it true that only user who have Postgres superuser privilege can use lo_export(). tq in advance..

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