Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

I'm wanting to add a simple javascript popup window to several hundred product descriptions. But EasyPopulate gives an error because of the use of quotation marks in my code. Specifically, the HTML/javascript description I've tried to paste into the fields in my EP file is as follows:

 

<p>Look to the Black & White photos for the <strong>SHAPE</strong> of the bead.  To view the color note the <strong>COLOR NUMBER</strong> beside the color name and <a onclick=/"window.open('http://www.bellinghambeadbazaar.com/images/guatemalanclaycolors.jpg','popup','toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=82
5,height=500,left = 400,top = -468'); return false/" href=/"../../../images/guatemalanclaycolors.jpg/">click to see the color guide</a>.  The colors are arranged by number.</p>

 

The error that EasyPopulate spits out is:

 

1064 - You have an error in your SQL syntax near 'http://www.bellinghambeadbazaar.com/images/guatemalanclaycolors.jpg','popup','to' at line 3

UPDATE products_description SET products_name='2-Pink Stamped Round Tube-Lrg/24-30x10-12mm/Qty 10', products_description='

Look to the Black & White photos for the SHAPE of the bead.  To view the color note the COLOR NUMBER beside the color name and click to see the color guide.  The colors are arranged by number.
', products_url='

Look to the Black & White photos for the SHAPE of the bead.  To view the color note the COLOR NUMBER beside the color name and click to see the color guide.  The colors are arranged by number.
' WHERE products_id = '72' AND language_id = '1'

[TEP STOP]

 

Anyone have any ideas for getting the double quotes in there?

 

Thanks ahead of time,

Gheffron

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...