 |
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
March 10th, 2006, 01:58 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Did you try replacing the apostrophes?
Can you post the sql that is causing the errors?
Cheers,
Chris
|
|
March 16th, 2006, 06:04 AM
|
|
Friend of Wrox
|
|
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Code:
set rs2=con.execute("SELECT country FROM `stadiums` WHERE countryname LIKE '"&choice&"%'", ,adCmdText)
www.crmpicco.co.uk
|
|
March 16th, 2006, 07:35 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
The sql statement itself please, not the code that creates it.
Cheers,
Chris
|
|
March 16th, 2006, 01:40 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
SELECT county FROM Stadiums where countryname like '&scotland&'
www.crmpicco.co.uk
|
|
March 16th, 2006, 02:01 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Query runs fine for me with no errors.
|
|
March 17th, 2006, 09:03 AM
|
|
Friend of Wrox
|
|
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
but try putting an apostrophe (') into the variable 'scotland'.........................
it all goes Pete Tong!
www.crmpicco.co.uk
|
|
March 17th, 2006, 11:12 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Yep, but like I said, replace apostrophes with two apostrophes and it will work.
|
|
March 21st, 2006, 08:55 AM
|
|
Friend of Wrox
|
|
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
yeah, that worked great Chris. it will catch the bad characters both Client-Side and Server-Side now. thank you.
www.crmpicco.co.uk
|
|
March 21st, 2006, 12:34 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
March 22nd, 2006, 05:06 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi Picco,
The function I posted works fine for me in IE, Mozilla & Opera.
Cheers,
Chris
|
|
|
