Search results for query: *

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

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

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

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

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

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