Re: Witango-Talk: case matching
utf8_bin, is case sensitive. You want to use utf8_general or utf8_general_ci for mostly text fields. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Apr 20, 2010, at 12:42 PM, Roland Dumas wrote: > hmm, playing with this. For UTF8, the collation options are utf8_bin and then > a series of language specific _ci options. > > for ascii, there are choices of ascii_bin and ascii_general_ci > > etc. > > > On Apr 20, 2010, at 12:32 PM, Robert Garcia wrote: > >> MySQL is not case insensitive. MySQL can EITHER be case sensitive, or case >> insensitive. >> >> When you setup a database, or table, or even at the column level, there is a >> COLLATION option. So if you are using encoding of UTF8, then you are >> probably using collation of utf8_general_ci. That "ci" on the end, means >> "case insensitive". If you use utf8_general as your collation, it is CASE >> SENSITIVE. You set collation at the default level for each database, but you >> can change a table default, and you can even set this per column if >> necessary. Generally, it is good practice to make password CASE SENSITIVE. >> >> -- >> >> Robert Garcia >> President - BigHead Technology >> VP Application Development - eventpix.com >> 15520 Coutelenc Rd >> Magalia, Ca 95954 >> ph: 530.645.4040 x222 fax: 530.645.4040 >> rgar...@bighead.net - rgar...@eventpix.com >> http://bighead.net/ - http://eventpix.com/ >> >> On Apr 20, 2010, at 11:09 AM, Roland Dumas wrote: >> >>> and the follow-up >>> >>> witango is case insensitive. seems that mysql is also case insensitive. >>> >>> How do I set a look-up that is case sensitive? So that password is >>> not the same as ? >>> >>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >>> >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Spammers
What I do is have people solve a simple math problem (ie. 3 + 4 = ?) where they would enter 7 in a text box. The first two numbers are random single digit numbers so that answer will change each time. This is easy to implement and seems to work well. Stefan From: "Ted Wolfley" Sent: Tuesday, April 20, 2010 3:34 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Spammers Hi, I tried a CAPTHA but didn't have any luck. Then I read it is better to have the person uncheck a checkbox before submitting. Ted From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Tuesday, April 20, 2010 3:20 PM To: witango-talk@witango.com Subject: Witango-Talk: Spammers I had a little misfortune this last weekend. I have a "Recommend It" program on our commerce sites where someone can recommend the site to their friends by entering up to 3 email address and a personal comment and then the program emails accordingly. You guessed it, I believe someone wrote a crone program to use this to send out spam. Started on Saturday afternoon and ended when I caught it Monday morning. Ironically the ip address originates down under in Australia. They must be familiar with the "taf" extension down there. LOL What are you guys doing to prevent this. CAPTCHA? Or some other strategy? If it is CAPTCHA, could you recommend where I could obtain a bunch CAPTCHA images so I can create this step to hopefully keep spammers from using the program.? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: case matching
ok, I see. If I set char set at ascii and collation at ascii_bin, then the match becomes case sensitive. Simplest solution. thank you, again. On Apr 20, 2010, at 12:32 PM, Robert Garcia wrote: > MySQL is not case insensitive. MySQL can EITHER be case sensitive, or case > insensitive. > > When you setup a database, or table, or even at the column level, there is a > COLLATION option. So if you are using encoding of UTF8, then you are probably > using collation of utf8_general_ci. That "ci" on the end, means "case > insensitive". If you use utf8_general as your collation, it is CASE > SENSITIVE. You set collation at the default level for each database, but you > can change a table default, and you can even set this per column if > necessary. Generally, it is good practice to make password CASE SENSITIVE. > > -- > > Robert Garcia > President - BigHead Technology > VP Application Development - eventpix.com > 15520 Coutelenc Rd > Magalia, Ca 95954 > ph: 530.645.4040 x222 fax: 530.645.4040 > rgar...@bighead.net - rgar...@eventpix.com > http://bighead.net/ - http://eventpix.com/ > > On Apr 20, 2010, at 11:09 AM, Roland Dumas wrote: > >> and the follow-up >> >> witango is case insensitive. seems that mysql is also case insensitive. >> >> How do I set a look-up that is case sensitive? So that password is not >> the same as ? >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: case matching
hmm, playing with this. For UTF8, the collation options are utf8_bin and then a series of language specific _ci options. for ascii, there are choices of ascii_bin and ascii_general_ci etc. On Apr 20, 2010, at 12:32 PM, Robert Garcia wrote: > MySQL is not case insensitive. MySQL can EITHER be case sensitive, or case > insensitive. > > When you setup a database, or table, or even at the column level, there is a > COLLATION option. So if you are using encoding of UTF8, then you are probably > using collation of utf8_general_ci. That "ci" on the end, means "case > insensitive". If you use utf8_general as your collation, it is CASE > SENSITIVE. You set collation at the default level for each database, but you > can change a table default, and you can even set this per column if > necessary. Generally, it is good practice to make password CASE SENSITIVE. > > -- > > Robert Garcia > President - BigHead Technology > VP Application Development - eventpix.com > 15520 Coutelenc Rd > Magalia, Ca 95954 > ph: 530.645.4040 x222 fax: 530.645.4040 > rgar...@bighead.net - rgar...@eventpix.com > http://bighead.net/ - http://eventpix.com/ > > On Apr 20, 2010, at 11:09 AM, Roland Dumas wrote: > >> and the follow-up >> >> witango is case insensitive. seems that mysql is also case insensitive. >> >> How do I set a look-up that is case sensitive? So that password is not >> the same as ? >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: case matching
another winner suggestion. thank you again. On Apr 20, 2010, at 11:27 AM, Robert Shubert wrote: > I know for sure that @cipher is in 5.0, but it may work a little > differently. > > You certainly can do this comparison in the search action if you: > > A) store the password as the HASH (do one of the @ciphers when you set the > password) > Or > B) use MySQLs HASH function, at quick glance I think you would do > "MD5(password_column)" as a custom search criteria column. > > Since I use Witango 5.5 and MS SQL primarily, YMMV > > Robert > > -Original Message- > From: Roland Dumas [mailto:radu...@mac.com] > Sent: Tuesday, April 20, 2010 2:19 PM > To: witango-talk@witango.com > Subject: Re: Witango-Talk: case matching > > <@cipher> in witango 5.0? > > if so, can this be done in the search action? > > > On Apr 20, 2010, at 11:14 AM, Robert Shubert wrote: > >> @IF <@CIPHER action=hash type=md5 str=db_password> = <@CIPHER action=hash >> type=md5 str=arg_password> >> >> -Original Message- >> From: Roland Dumas [mailto:radu...@mac.com] >> Sent: Tuesday, April 20, 2010 2:09 PM >> To: witango-talk@witango.com >> Subject: Witango-Talk: case matching >> >> and the follow-up >> >> witango is case insensitive. seems that mysql is also case insensitive. >> >> How do I set a look-up that is case sensitive? So that password is > not >> the same as ? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Spammers
Hi, I tried a CAPTHA but didn't have any luck. Then I read it is better to have the person uncheck a checkbox before submitting. Ted From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Tuesday, April 20, 2010 3:20 PM To: witango-talk@witango.com Subject: Witango-Talk: Spammers I had a little misfortune this last weekend. I have a "Recommend It" program on our commerce sites where someone can recommend the site to their friends by entering up to 3 email address and a personal comment and then the program emails accordingly. You guessed it, I believe someone wrote a crone program to use this to send out spam. Started on Saturday afternoon and ended when I caught it Monday morning. Ironically the ip address originates down under in Australia. They must be familiar with the "taf" extension down there. LOL What are you guys doing to prevent this. CAPTCHA? Or some other strategy? If it is CAPTCHA, could you recommend where I could obtain a bunch CAPTCHA images so I can create this step to hopefully keep spammers from using the program.? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: case matching
MySQL is not case insensitive. MySQL can EITHER be case sensitive, or case insensitive. When you setup a database, or table, or even at the column level, there is a COLLATION option. So if you are using encoding of UTF8, then you are probably using collation of utf8_general_ci. That "ci" on the end, means "case insensitive". If you use utf8_general as your collation, it is CASE SENSITIVE. You set collation at the default level for each database, but you can change a table default, and you can even set this per column if necessary. Generally, it is good practice to make password CASE SENSITIVE. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Apr 20, 2010, at 11:09 AM, Roland Dumas wrote: > and the follow-up > > witango is case insensitive. seems that mysql is also case insensitive. > > How do I set a look-up that is case sensitive? So that password is not > the same as ? > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: case matching
ah, this works on 5.0 Thanks! On Apr 20, 2010, at 11:14 AM, Robert Shubert wrote: > @IF <@CIPHER action=hash type=md5 str=db_password> = <@CIPHER action=hash > type=md5 str=arg_password> > > -Original Message- > From: Roland Dumas [mailto:radu...@mac.com] > Sent: Tuesday, April 20, 2010 2:09 PM > To: witango-talk@witango.com > Subject: Witango-Talk: case matching > > and the follow-up > > witango is case insensitive. seems that mysql is also case insensitive. > > How do I set a look-up that is case sensitive? So that password is not > the same as ? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Spammers
I had a little misfortune this last weekend. I have a "Recommend It" program on our commerce sites where someone can recommend the site to their friends by entering up to 3 email address and a personal comment and then the program emails accordingly. You guessed it, I believe someone wrote a crone program to use this to send out spam. Started on Saturday afternoon and ended when I caught it Monday morning. Ironically the ip address originates down under in Australia. They must be familiar with the "taf" extension down there. LOL What are you guys doing to prevent this. CAPTCHA? Or some other strategy? If it is CAPTCHA, could you recommend where I could obtain a bunch CAPTCHA images so I can create this step to hopefully keep spammers from using the program.? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: case matching
I know for sure that @cipher is in 5.0, but it may work a little differently. You certainly can do this comparison in the search action if you: A) store the password as the HASH (do one of the @ciphers when you set the password) Or B) use MySQLs HASH function, at quick glance I think you would do "MD5(password_column)" as a custom search criteria column. Since I use Witango 5.5 and MS SQL primarily, YMMV Robert -Original Message- From: Roland Dumas [mailto:radu...@mac.com] Sent: Tuesday, April 20, 2010 2:19 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: case matching <@cipher> in witango 5.0? if so, can this be done in the search action? On Apr 20, 2010, at 11:14 AM, Robert Shubert wrote: > @IF <@CIPHER action=hash type=md5 str=db_password> = <@CIPHER action=hash > type=md5 str=arg_password> > > -Original Message- > From: Roland Dumas [mailto:radu...@mac.com] > Sent: Tuesday, April 20, 2010 2:09 PM > To: witango-talk@witango.com > Subject: Witango-Talk: case matching > > and the follow-up > > witango is case insensitive. seems that mysql is also case insensitive. > > How do I set a look-up that is case sensitive? So that password is not > the same as ? > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: case matching
<@cipher> in witango 5.0? if so, can this be done in the search action? On Apr 20, 2010, at 11:14 AM, Robert Shubert wrote: > @IF <@CIPHER action=hash type=md5 str=db_password> = <@CIPHER action=hash > type=md5 str=arg_password> > > -Original Message- > From: Roland Dumas [mailto:radu...@mac.com] > Sent: Tuesday, April 20, 2010 2:09 PM > To: witango-talk@witango.com > Subject: Witango-Talk: case matching > > and the follow-up > > witango is case insensitive. seems that mysql is also case insensitive. > > How do I set a look-up that is case sensitive? So that password is not > the same as ? > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: case matching
@IF <@CIPHER action=hash type=md5 str=db_password> = <@CIPHER action=hash type=md5 str=arg_password> -Original Message- From: Roland Dumas [mailto:radu...@mac.com] Sent: Tuesday, April 20, 2010 2:09 PM To: witango-talk@witango.com Subject: Witango-Talk: case matching and the follow-up witango is case insensitive. seems that mysql is also case insensitive. How do I set a look-up that is case sensitive? So that password is not the same as ? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: case matching
and the follow-up witango is case insensitive. seems that mysql is also case insensitive. How do I set a look-up that is case sensitive? So that password is not the same as ? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: random password generator
I like passwords that are more memorable. There are webservices you could call with @URL that could provide that, here is one I saw. http://www.diplodock.com/Products/PasswordGenerator/WebService/default.aspx There are many others. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Apr 20, 2010, at 9:26 AM, Roland Dumas wrote: > > any ideas on how to generate temporary passwords in witango? @RANDOM will > give me an integer, yes, but how to create combination of integer/alpha not > obvious. > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: random password generator
thank you all for privately and posted snippets. On Apr 20, 2010, at 9:26 AM, Roland Dumas wrote: > > any ideas on how to generate temporary passwords in witango? @RANDOM will > give me an integer, yes, but how to create combination of integer/alpha not > obvious. > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: random password generator
In pseudo code: <@FOR stop=8> <@assign ascii_val <@random low=97 high=122>> <@assign password '@@password<@char @@acsii_val>'> Of course, you can use a other ascii ranges for the numbers, capital letters and special characters. In fact, I think nearly all ascii values from 33 through 126 are acceptable. Robert -Original Message- From: Roland Dumas [mailto:radu...@mac.com] Sent: Tuesday, April 20, 2010 12:27 PM To: WiTango List List Subject: Witango-Talk: random password generator any ideas on how to generate temporary passwords in witango? @RANDOM will give me an integer, yes, but how to create combination of integer/alpha not obvious. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: random password generator
Roland, Here's one way: <@EXCLUDE> <@ASSIGN request$pwSpecChars value="!...@#$&*+=?"> <@ASSIGN request$PWValidChars value="ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz23456789<@VAR request$pwSpecChars>"> <@ASSIGN request$pwValidLen value="<@LENGTH '@@local$pwValidChars'>"> <@IFEMPTY "<@ARG pwLen>"> <@ASSIGN request$pwLen value="5"> <@ELSE> <@ASSIGN request$pwLen value="<@ARG pwLen>"> <@ASSIGN request$suggestedPW value=""> <@FOR START="1" STEP="1" STOP="@@request$pwLen"> <@ASSIGN request$suggestedPW value="<@VAR request$suggestedPW><@SUBSTRING STR='@@request$pwValidChars' START='<@RANDOM HIGH="@@request$pwValidLen" LOW="1">' NUMCHARS='1'>"> Bill On Tue, Apr 20, 2010 at 9:26 AM, Roland Dumas wrote: > > any ideas on how to generate temporary passwords in witango? @RANDOM will > give me an integer, yes, but how to create combination of integer/alpha not > obvious. > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: random password generator
any ideas on how to generate temporary passwords in witango? @RANDOM will give me an integer, yes, but how to create combination of integer/alpha not obvious. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf