Recent content by teroy

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

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

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

thanks for your help guys :)

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

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

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

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

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

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

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

Thankyou PGExplorer.. That worked perfectly :)

thanks guys.. :)

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

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