Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Web Programming > JavaScript > Javascript How-To
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Javascript How-To Ask your "How do I do this with Javascript?" questions here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Javascript How-To section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old March 10th, 2006, 01:58 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Did you try replacing the apostrophes?

Can you post the sql that is causing the errors?

Cheers,

Chris

Reply With Quote
  #12 (permalink)  
Old March 16th, 2006, 06:04 AM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

Code:
set rs2=con.execute("SELECT country FROM `stadiums` WHERE countryname LIKE '"&choice&"%'", ,adCmdText)

www.crmpicco.co.uk
Reply With Quote
  #13 (permalink)  
Old March 16th, 2006, 07:35 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

The sql statement itself please, not the code that creates it.

Cheers,

Chris

Reply With Quote
  #14 (permalink)  
Old March 16th, 2006, 01:40 PM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

SELECT county FROM Stadiums where countryname like '&scotland&'

www.crmpicco.co.uk
Reply With Quote
  #15 (permalink)  
Old March 16th, 2006, 02:01 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Query runs fine for me with no errors.

Reply With Quote
  #16 (permalink)  
Old March 17th, 2006, 09:03 AM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

but try putting an apostrophe (') into the variable 'scotland'.........................

it all goes Pete Tong!

www.crmpicco.co.uk
Reply With Quote
  #17 (permalink)  
Old March 17th, 2006, 11:12 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Yep, but like I said, replace apostrophes with two apostrophes and it will work.

Reply With Quote
  #18 (permalink)  
Old March 21st, 2006, 08:55 AM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

yeah, that worked great Chris. it will catch the bad characters both Client-Side and Server-Side now. thank you.

www.crmpicco.co.uk
Reply With Quote
  #19 (permalink)  
Old March 21st, 2006, 12:34 PM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

Code:
/*
FUNCTION NAME: fix_chars
Replace specific characters with [BLANK] as they are no valid city/airport code entries
*/
function fix_chars(id,val)
{
       var doce = document.forms["fexp"].elements;

       if ((typeof(val)=="undefined")||(typeof(id)=="undefined")){
        return;
    }
    if(/'/.test(val))
    {
        doce[id].value = val.replace(/'/g,'');
    }
    if(/&/.test(val))
    {
        doce[id].value = val.replace(/&/g,'');
    }
    if(/_/.test(val))
    {
        doce[id].value = val.replace(/_/g,'');
    }
    if(/,/.test(val))
    {
        doce[id].value = val.replace(/,/g,'');
    }
    if(/%/.test(val))
    {
        doce[id].value = val.replace(/%/g,'');
    }
    if(/`/.test(val))
    {
        doce[id].value = val.replace(/`/g,'');
    }
    if(/"/.test(val))
    {
        doce[id].value = val.replace(/"/g,'');
    }
    if(/@/.test(val))
    {
        doce[id].value = val.replace(/@/g,'');
    }
    if(/~/.test(val))
    {
        doce[id].value = val.replace(/~/g,'');
    }
    if(/#/.test(val))
    {
        doce[id].value = val.replace(/#/g,'');
    }
    if(/!/.test(val))
    {
        doce[id].value = val.replace(/!/g,'');
    }
    if(/</.test(val))
    {
        doce[id].value = val.replace(/</g,'');
    }
    if(/>/.test(val))
    {
        doce[id].value = val.replace(/>/g,'');
    }
    if(/{/.test(val))
    {
        doce[id].value = val.replace(/{/g,'');
    }
    if(/}/.test(val))
    {
        doce[id].value = val.replace(/}/g,'');
    }
}
chris, on further testing the function you posted didnt actually work, this code works, but again, it looks crazy. can it be cut down??

i'm not sure why yours didnt work, it looked fine!

www.crmpicco.co.uk
Reply With Quote
  #20 (permalink)  
Old March 22nd, 2006, 05:06 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Picco,

The function I posted works fine for me in IE, Mozilla & Opera.

Cheers,

Chris

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove characters from "=" and before ymeyaw Excel VBA 2 February 27th, 2007 06:02 AM
Custom script to remove special characters midoriweb Classic ASP Basics 2 January 12th, 2007 08:05 AM
asp variable declaration bad characters crmpicco Classic ASP Basics 2 August 18th, 2005 07:49 AM
characters a MySQL DB cannot deal with crmpicco MySQL 1 May 9th, 2005 07:15 AM
Want to get Polish characters from mySQL db zarol Beginning PHP 2 April 13th, 2005 09:20 AM



All times are GMT -4. The time now is 06:54 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.