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!

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

Search results for query: *

  • Users: teroy
  • Order by date
  1. teroy

    query help - sum & group

    Hi guys, I have records that look like the following custname | custgroup | queryname | subnet | day | hour | dbytes | ubytes ----------+---------------+-------------+--------------+-----+------+----------+-------- cee | SOHO DSL User | chargeddata | 202.137.73.2 |...
  2. teroy

    no statement executing

    hi guys, I got the following error in my log files when i run a sql statement that does not return a value for fields ina recordset [Thu May 8 16:30:50 2003] missing_fields.cgi: no statement executing at /home/troyr/public_html/2002/platypus_contacts/tools/missing_fields.cgi line 56...
    • teroy
    • Thread
    • Replies: 0
    • Forum: Perl
  3. teroy

    adding values from diff records

    From swampboogies example i am using SELECT sum(o.frequency), l.id, l.name, l.keywords FROM links l, object_word_link o, word w WHERE l.id=o.object_id AND w.id=o.word_id AND w.object_count/7366 < 0.7 AND ( lower(w.word) in ('melbourne','citysearch')...
  4. teroy

    adding values from diff records

    thanks for your help guys :)
  5. teroy

    Fulltext search

    i found the following at http://zez.org/article/view/83/ which is for php and mysql...its easy enough to convert to postgres. it has a few problems but its an okay startin point
  6. teroy

    adding values from diff records

    hi guys.. i have a select statement which goes like this SELECT l.id,o.frequency,o.frequency as freq1, l.name, l.url, l.description FROM links l, object_word_link o, word w WHERE l.id=o.object_id AND w.id=o.word_id AND ( lower(l.name || l.keywords) like '%melbourne%' AND lower(l.name ||...
  7. teroy

    query help

    sorry guys..my bad..i restructured the query and it works fine SELECT c.id, c.name, c.username, c.email FROM customer c, rgheader r, custrate cu WHERE 0 = 0 AND cu.custid = c.id AND cu.rgid = r.id AND (r.id = 200 OR r.id = 180) AND (NOT c.tech_record = 1) Cheers
  8. teroy

    query help

    Hi Guys, i have the following sql statement SELECT c.id, c.name, c.username, c.email FROM customer c, rgheader r, custrate cu WHERE 0 = 0 AND NOT tech_record = 1 AND cu.custid = c.id AND cu.rgid = r.id AND r.id = 200 Now this works okay....but if i want to modify the last line like...
  9. teroy

    perl and sql server - per page

    hi guys, i was wondering how you guys deal with giving the user a per page option with a cgi script using perl and sql server. When i use perl and postgres i use select field from table limit $num offset $num as far as i can tell..i can't find something similiar for sql server...ie...
    • teroy
    • Thread
    • Replies: 1
    • Forum: Perl
  10. teroy

    can i database in perl? need to organize inputs from a form...

    man DBI theres plenty of examples in there you would also need to decide what database to use postgres and mysql are good choices for linux
  11. teroy

    HTML Form to Txt File

    The code should not be displayed It should execute... Make sure that your webserver has the .pl extension associated with the perl executable
  12. teroy

    Functions &amp; Triggers

    Thankyou PGExplorer.. That worked perfectly :)
  13. teroy

    date manipulations

    thanks guys.. :)
  14. teroy

    date manipulations

    Hi there.. I have a variable which contains a date..say my $var=&quot;1940/12/12/&quot;; Is there any module around that gets the difference between this date and the current time. So basically something which returns ($year,$month,$days) So it can be presented like You are 50 years, 3...
    • teroy
    • Thread
    • Replies: 3
    • Forum: Perl
  15. teroy

    regular expression

    Thankyou Goaboating...sorry my explanation was a bit incomprehensible. Your solution nearly worked for me example basically the url could be anywhere in the string..and it might contain http:// or it might just contain www.whateva my $test=&quot;www.vicnet.net.au check out this link...
  16. teroy

    Checking vars from flatfile

    Hi Jim, it would be helpful if you had some sample code, or a few lines from your flat file table Cheers troy
  17. teroy

    regular expression

    Hi Guys, I have the following string my $test=&quot;www.vicnet.net.au check out this link www.vicnet.net.au it could be http://www.vicnet.net.au&quot;; and a regex which follows: $test=~s/[^\/]www*\b/ http:\/\/www$1/gi; what i want to happen..is if it finds www i want it to add...
    • teroy
    • Thread
    • Replies: 2
    • Forum: Perl
  18. teroy

    limit &amp; offset

    Hi there, I was wondering if sql server has a command to only get an offset of records specified. ie so if you only wanted to return 10 records you could do so..but you can start from the 20th record returned..instead of the 1st in other sql apps (ie postgresql) you can do select * from...
  19. teroy

    timestamp

    Hi There, Is there a way i can declare the timestamp field without it adding the 'with timezone' section ? thanks in advance. troy
  20. teroy

    select * not working

    hi doddo...at the psql terminal have u tried to type select * from and then type in the first few letters of the table then hit tab..and see if it completes the table name for you.. ?

Part and Inventory Search

Back
Top