 HELP: Stupid Display Bug Fix, I think I've got it, need SQL scripter |
|
|
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
|
| McMark |
 Aug 15 2006, 06:21 PM
Post
#1
|
|
914 Freak!  Group: Retired Admin Posts: 20,180 Joined: 13-March 03 From: Grand Rapids, MI Member No.: 419 Region Association: None  |
The stupid problem where post content doesn't appear looks like it's caused by improper HTML quotes. The erroneous quotes appear like this <!--XXXXXX--> and they should appear like this <!-- XXXXXX --> (notice the extra whitespace). So we need a SQL query that will search for <!-- followed by a character and add in a space, and another query to search for --> preceded by a character and add in a space. I have a bunch of other stuff to do, can someone savvy write the queries for me so I can run them?
|
   |
 
|
  |
Replies
| lapuwali |
Aug 15 2006, 06:34 PM
Post
#2
|
|
Not another one! Group: Benefactors Posts: 4,526 Joined: 1-March 04 From: San Mateo, CA Member No.: 1,743  |
Alas, SQL by itself doesn't really handle strings well enough to do what you want. I could write this in Perl in a few minutes. I *think* MySQL my also have some tricks to handle this, let me look in the MySQL docs...
|
|
|
|
| SirAndy |
Aug 15 2006, 06:42 PM
Post
#3
|
|
Resident German Group: Admin Posts: 42,244 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California |
QUOTE(lapuwali @ Aug 15 2006, 05:34 PM)  Alas, SQL by itself doesn't really handle strings well enough to do what you want. I could write this in Perl in a few minutes. I *think* MySQL my also have some tricks to handle this, let me look in the MySQL docs... (IMG:style_emoticons/default/agree.gif) just write a PHP script that loops through the DB and replaces the wrong entries ... (IMG:style_emoticons/default/type.gif) Andy |
|
|
|
Posts in this topic
McMark HELP: Stupid Display Bug Fix Aug 15 2006, 06:21 PM
SirAndy |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 4th July 2025 - 03:24 AM |
Invision Power Board
v9.1.4 © 2025 IPS, Inc.
| All rights reserved 914World.com © since 2002 |
|
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |