Home  |  Forums  |  914 Info  |  Blogs
 
914World.com - The fastest growing online 914 community!
 
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.
 

Welcome Guest ( Log In | Register )

> HELP: Stupid Display Bug Fix, I think I've got it, need SQL scripter
McMark
post 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?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
 
Reply to this topicStart new topic
Replies
lapuwali
post 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...
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Posts in this topic
McMark   HELP: Stupid Display Bug Fix   Aug 15 2006, 06:21 PM
lapuwali   Alas, SQL by itself doesn't really handle stri...   Aug 15 2006, 06:34 PM
SirAndy  

Reply to this topicStart new topic
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:54 AM