Re: How to count the number of ,br's in multiple records
ASP - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 5:45 PM Subject: Re: How to count the number of ,br's in multiple records On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote: How do I count the number br's in each record in a field? Using what programming language? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to count the number of ,br's in multiple records
At 5:59 PM -0500 9/16/01, Deryck Henson wrote: ASP You tell us, then. MySQL doesn't have a function to count the number of instances of a substring within a string. At least I don't think it does. Does ASP have some kind of function for that? If so, you can run a SELECT that looks for records containing br, then use the ASP function to count instances, summed over each matching record. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 5:45 PM Subject: Re: How to count the number of ,br's in multiple records On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote: How do I count the number br's in each record in a field? Using what programming language? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec. avg) -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to count the number of ,br's in multiple records
something like this (assuming vbscript): Dim pos = 1 Dim cnt = 0 Do pos = InStr(field, br, pos) If pos 0 Then cnt = cnt + 1 pos = pos + 3 'get past the current one Else break End If Loop 'at this point, cnt holds your answer -Original Message- From: Deryck Henson [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 7:00 PM To: [EMAIL PROTECTED] Subject: Re: How to count the number of ,br's in multiple records Importance: High ASP - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 5:45 PM Subject: Re: How to count the number of ,br's in multiple records On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote: How do I count the number br's in each record in a field? Using what programming language? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to count the number of ,br's in multiple records
On Sun, Sep 16, 2001 at 05:59:48PM -0500, Deryck Henson wrote: Using what programming language? ASP That's a framework (or API), not a language. (see Paul's answer anyway) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 201,122,168 queries (215/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php