Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - How to customize inserted hyperlinks? Part 2
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedHow to customize inserted hyperlinks? Part 2

 Post Reply Post Reply Page  <12
Author
Finlay View Drop Down
Newbie
Newbie


Joined: 31 October 2006
Location: United Kingdom
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote Finlay Quote  Post ReplyReply Direct Link To This Post Posted: 01 November 2006 at 4:53pm
The other elements of teh replace function all work fine and even amending it to the following :

function fixQuotes(strData)
    strData = Replace(strData, "'", "''")
    strData = Replace(strData,"boy", "girl")   
    strData = Replace(strData,chr(34), chr(34) & chr (34))     
   fixQuotes =  strData 
end function

still leaves the string being cut off at the double quote when being entered to the database.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 01 November 2006 at 4:57pm
I'm not sure what you are doing wrong as your code is not very well written, but I have never found any issue with entering the double quote mark into a database, single quotes have to be escaped by replacing then with two single quite markes but nothing else.

try:-

desc = Replace(desc, "'", "''")

 SQLstmt = SQLstmt & "Description='" & desc  & "',"
Back to Top
Finlay View Drop Down
Newbie
Newbie


Joined: 31 October 2006
Location: United Kingdom
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote Finlay Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2006 at 11:51am
This didn't work either but I basically createed a new form and table in the database that worked fine.

After this, I was able to track the error to how input fields were created in a form that allowed users to double check their entries. It was something along the lines of:
                response.write "<input type='hidden' name='"
                response.write  Name & "' value=" & chr(34) & request.form(Name) & chr(34)
                response.write ">"

which I changed to

                response.write "<input type='hidden' name='"  & name & "' value='" & request.form(name) & "'>"

And the whole thing worked like a charm.

Of course, none of this had anything to do with the RTE editor which has worked 100% throughout but you never know, in a 100 years time this post may help someone else out. Right...I'm off for a celebratory brew!

Thanks very much for your assistance and reponses during this whole brouhaha.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.