Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JJJ777

  1. JJJ777

    php development tools

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

    php development tools

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

    trigger insert/update when date changes

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

    HELP : this javascript script do not work in firefox but work in ie

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

    add another row dynamically

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

    HELP : this javascript script do not work in firefox but work in ie

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

    data type money in postgres

    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)
  8. JJJ777

    data type money in postgres

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

    data type money in postgres

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

    Make ORG-CHART using php ?

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

    i tried to use trigger

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

    trigger /rules/agregate which one to use?

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

    comparing 2 string

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

    join table which column type integer []

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

    user management..security page control

    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

Part and Inventory Search

Back
Top