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