PPPMBOT Log for Oct 2003
Steve Smythe
ssmythe at docent.com
Mon Nov 3 12:45:37 CST 2003
[Fri Oct 10 11:36:48 2003] <ssmythe:#perl> pppmbot Please tell me another
funny joke.
[Fri Oct 10 11:36:49 2003] <pppmbot:#perl> ssmythe... Best file compression
around: "DEL *.*" = 100% compression
[Fri Oct 10 11:45:00 2003] <jopa:#perl> well
[Fri Oct 10 11:45:03 2003] <jopa:#perl> SELECT Count(*) FROM members WHERE
((startdate > '1') AND (startdate <= '30'));
[Fri Oct 10 11:45:08 2003] <jopa:#perl> is valid
[Fri Oct 10 11:45:15 2003] <jopa:#perl> if that helps any
[Fri Oct 10 11:45:47 2003] <jopa:#perl> but i format my date different, so,
I can't fully test
[Fri Oct 10 11:47:20 2003] <jopa:#perl> SELECT Count(*) FROM members WHERE
((startdate > #1#) AND (startdate <= #30#));
[Fri Oct 10 11:47:24 2003] <jopa:#perl> pukes for me
[Fri Oct 10 11:47:29 2003] <jopa:#perl> in mysql
[Fri Oct 10 11:49:30 2003] <ssmythe:#perl> I'll pass that along to him.
Thanks for your investigation on this.
[Fri Oct 10 11:51:03 2003] <ssmythe:#perl> ah
[Fri Oct 10 11:51:16 2003] <ssmythe:#perl> he just sent a reply... he said:
[Fri Oct 10 11:51:17 2003] <ssmythe:#perl> I got it figured out...
[Fri Oct 10 11:51:17 2003] <ssmythe:#perl>
[Fri Oct 10 11:51:17 2003] <ssmythe:#perl> If I tried to build up the query
string within perl using concatenated strings and variables, and then
execute it, it failed. If I instead passed the variable parts through as
bound variables, it worked. Dunno what would be different by allowing the
execute function construct the query - the text in either case was exactly
the same.
[Fri Oct 10 11:51:17 2003] <ssmythe:#perl>
[Fri Oct 10 11:51:28 2003] <ssmythe:#perl> ... does this make sense?
[Fri Oct 10 11:52:14 2003] <jopa:#perl> no
[Fri Oct 10 11:52:18 2003] <ssmythe:#perl> hehe
[Fri Oct 10 11:52:23 2003] <jopa:#perl> ;)
[Fri Oct 10 11:52:31 2003] <ssmythe:#perl> I think it's how he's calling
their query... I think that's what he means...
[Fri Oct 10 11:53:09 2003] <ssmythe:#perl> using the (*) type features of
SQL and when making the DBI call, using parameterized replacements for the
(*) part of the call
[Fri Oct 10 11:53:46 2003] <ssmythe:#perl> something like
whateverQueryFunctionItsCalled($query, $value1, $value2, $value3)...
[Fri Oct 10 11:53:49 2003] <ssmythe:#perl> ya know?
[Fri Oct 10 11:53:52 2003] <ssmythe:#perl> heya Tim
[Fri Oct 10 11:54:09 2003] <tbc:#perl> Hi, Steve.
[Fri Oct 10 11:55:24 2003] <ssmythe:#perl> well, I think it's time for
food! :-) Thanks again jopa for your help.
[Fri Oct 10 11:55:34 2003] <ssmythe:#perl> be back later
[Fri Oct 10 11:55:40 2003] <jopa:#perl> no prob, have a good lunch
[Fri Oct 10 11:55:46 2003] <tbc:#perl> later, ssmythe
[Fri Oct 10 11:56:08 2003] <jopa:#perl> hi Tim
[Fri Oct 10 13:38:30 2003] <tbc:#perl> jopa: hi, didn't mean to ignore you
-- busy day at work
[Fri Oct 10 13:48:35 2003] <jopa:#perl> no prob
[Wed Oct 29 11:58:42 2003] <tbc:#perl> Hi, jopa. Is that your 'bot with us?
[Wed Oct 29 15:14:29 2003] <jopa:#perl> nope, its still steves bot
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/archives/pikes-peak-pm/attachments/20031103/8748f7be/attachment.htm
More information about the Pikes-peak-pm
mailing list