Custom Query (13 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:

Results (10 - 12 of 13)

← 1 2 3 4 5 →
Ticket Resolution Summary Owner Reporter
#26 fixed Weed out ViaNet-isms Kris Deugau
Description

Trim out or generalize any remaining hardcoded ViaNet-specific bits.

Most of these are docu-comments referring to ViaNet IP ranges.

#29 invalid test ticket Kris Deugau Kris Deugau
Description

testing email

#34 fixed SQL cleanup - use DBI ? substitutions, move all SQL into IPDB.pm Kris Deugau
Description

Much of the SQL currently uses: 

 $sth = $dbh->prepare("INSERT INTO table (cols) values ('$literal1','$literal2')");
 $sth->execute;

instead of: 

 $sth = $dbh->prepare("INSERT INTO table (cols) values (?,?)");
 $sth->execute($literal1, $literal2);

Switching to CGI::Simple (#15) is exposing several places where this is problematic.

This is also something of an SQL-injection security issue - using DBI's parameter replacement means that user data goes right into the table, instead of munging the SQL (deliberately or otherwise).

← 1 2 3 4 5 →
Batch Modify
Note: See TracBatchModify for help on using batch modify.
Note: See TracQuery for help on using queries.