Hi!
I execute an SQL statement:
WHERE col2 IS NULL or col2 LIKE '0000-00-00%') and (col3 = '2')
The perl query looks like this:
WHERE col2 IS NULL or col2 LIKE '0000-00-00%') and (col3 = '2')");
I do not think I can replace this query with another GT::SQL method. GT::SQL::Condition seems does not know how to get a value from a column to another column. If yes, let me know, how!
Now I would like to count it using hits() method:
$hits = $links_db->hits;
But there is no any result counted.
How to count the result of the do_query?
Please help! Thanks!
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
I execute an SQL statement:
Code:
UPDATE $links_db SET col2 = col1 WHERE col2 IS NULL or col2 LIKE '0000-00-00%') and (col3 = '2')
The perl query looks like this:
Code:
$links_db->do_query("UPDATE apro_links SET col2 = col1 WHERE col2 IS NULL or col2 LIKE '0000-00-00%') and (col3 = '2')");
I do not think I can replace this query with another GT::SQL method. GT::SQL::Condition seems does not know how to get a value from a column to another column. If yes, let me know, how!
Now I would like to count it using hits() method:
$hits = $links_db->hits;
But there is no any result counted.
How to count the result of the do_query?
Please help! Thanks!
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...