Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

TeeJay (2309)

TeeJay
  (email not shown publicly)
http://www.aarontrevena.co.uk/

Working in Truro
Graduate with BSc (Hons) in Computer Systems and Networks
pm : london.pm, bath.pm, devoncornwall.pm
lug : Devon & Cornwall LUG
CPAN : TEEJAY [cpan.org]
irc : TeeJay
skype : hashbangperl
livejournal : hashbangperl [livejournal.com]
flickr :hashbangperl [flickr.com]

Journal of TeeJay (2309)

Monday July 22, 2002
06:28 AM

ASP is designed for people who can't program

[ #6535 ]
..which is probably why you can't actually program in it.

following last weeks trouble with queries that fetch records with BLOB columns, in short..

  • don't bother using getrows on recordsets with more than one BLOB
  • always specify the fields you want to fetch
  • always access the fields in that order

This morning I was surprised to discover that getRows() empties the current record of the recordset so you can't get any values out once you've called it.
Then I discovered that you can't put method calls into an array so 'aryRs = array(rs("foo"),rs("bar")) won't work and gives an error at line 0 (ASP error messages as unhelpful as ever, this also occurs if you miss a comma in an array).
so now I am forced to declare a variable for each column, populate each variable one by one from the recordset in the order of the select statement and then populate the array with the variables.

what a PITA.

Also this morning I came accross an annoyance when using ProxyPass in Apache - the header fields are emptied so I can't parse the path of where my mod_perl scripts are called from and have to use a variable instead. Easy to get around but being able to view the headers would be much more elegent.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.