Code within Code - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Code within Code

Author

Topic

ConradK
Posting Yak Master

140 Posts

Posted - 2010-03-16 : 18:48:56

So I am processing a database, and i need to kind of concatenate some html around some of the values to generate some webpages.

My code looks something like this
select
'html bla bla bla' + product.productname + 'more html bla///..""'

from products

and I keep getting errors like:
Your SQL is invalid: The identifier that starts with'

well I'm not sure what the problem is, and an 'identifier' that starts with ' is very vague. I'm thinking it has something to do with all the special characters like /.?"! that are in the html code I am trying to tack on, but am not sure what I can do to fix this.

Any help would be greatly apprciated.

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-16 : 19:38:12

Please post the actual code so that we can spot the problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-16 : 19:41:01

One suggestion would be to just return the column data and not do the concatenation until it gets returned to your application.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

ConradK
Posting Yak Master

140 Posts

Posted - 2010-03-16 : 20:26:31

[<form action=^http://search.stores.ebay.com/search/search.dll?GetResult^ method=^get^ target=^_blank^ name=^search^ id=^search^ style=^DISPLAY: inline; MARGIN-BOTTOM: 0px^><input type=^hidden^ checked=^checked^ value=^n^ name=^srchdesc^ /> <input type=^hidden^ value=^455482329^ name=^sid^ /> <input type=^hidden^ value=^UXSPORTS^ name=^store^ /> <input type=^hidden^ value=^0^ name=^colorid^ /> <input type=^hidden^ value=^0^ name=^fp^ /><table width=^899^ height=^1385^ border=^0^ align=^center^ cellpadding=^0^ cellspacing=^0^ id=^UXSports^ background=^http://imagehost.vendio.com/a/32022895/view/uxsports-bg.png^><tr><td height=^135^ colspan=^14^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_01.gif^ width=^559^ height=^94^ alt=^UXSports^></td><td colspan=^5^> </td> </tr><tr><td height=^49^ colspan=^8^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_03.gif^ width=^300^ height=^49^ alt=^The Best in Sports^></td> <td colspan=^3^> </td> <td colspan=^8^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_05.gif^ width=^487^ height=^49^ alt=^Questions? Give us a call^></td> </tr><tr><td height=^56^ colspan=^5^><a href=^http://stores.shop.ebay.com/UXsports^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_06.gif^ alt=^Our Store^ width=^225^ height=^56^ border=^0^></a></td><td colspan=^8^><a href=^http://feedback.ebay.com/ws/eBayISAPI.dll?ViewFeedback&userid=uxsports&ssPageName=VIP:feedback&ftab=FeedbackAsSeller^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_07.gif^ alt=^Feedback^ width=^225^ height=^56^ border=^0^></a></td> <td colspan=^2^><a href=^mailto:ebay@uxsports.com^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_08.gif^ alt=^Email Us^ width=^217^ height=^56^ border=^0^></a></td> <td colspan=^4^><a href=^http://my.ebay.com/ws/eBayISAPI.dll?AcceptSavedSeller&mode=0&preference=0&sellerid=uxsports^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_09.gif^ alt=^Add Us to Your Favorite Sellers^ width=^232^ height=^56^ border=^0^></a></td> </tr><tr> <td height=^41^ colspan=^4^> <img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_10.gif^ width=^184^ height=^41^ alt=^Search^></td> <td colspan=^6^ background=^http://imagehost.vendio.com/a/32022895/view/uxsports_11.png^ style=^padding-top:9px;^> <input name=^query^ style=^font-family: verdana; color: #000000; font-weight:bold; font-size: 14px;border: thin solid #FFFFFF;^ size=^23^ maxlength=^300^/></td> <td colspan=^2^><input type=^image^ alt=^go^ src=^http://imagehost.vendio.com/a/32022895/view/uxsports_12.gif^ value=^submit^ width=^47^ height=^41^ border=^0^ name=^image^ align=^middle^></td><td colspan=^7^> </td> </tr><tr><td height=^89^ colspan=^7^> <a href=^http://stores.ebay.com/UXsports_FITNESS-ITEMS_W0QQfsubZ8324478^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_14.gif^ alt=^Fitness Items^ width=^256^ height=^89^ border=^0^></a></td><td colspan=^2^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_15.png^ width=^51^ height=^89^ alt=^^></td><td colspan=^7^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_16.gif^ width=^422^ height=^89^ alt=^Most orders shipped by 3:00 PM^></td> <td colspan=^3^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_17.png^ width=^170^ height=^89^ alt=^^></td></tr><tr><td height=^654^ colspan=^6^ valign=^top^><a href=^http://stores.ebay.com/UXsports_PHITEN_W0QQfsubZ131107019^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_18.gif^ alt=^Phiten Items^ width=^254^ height=^106^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_RIFLE-ACCESSORIES_W0QQfsubZ182771119^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_20.gif^ alt=^Rifle Accessories^ width=^254^ height=^93^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_PISTOL-ACCESSORIES_W0QQfsubZ182771219^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_21.gif^ alt=^Pistol Accessories^ width=^254^ height=^94^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_POLICE-MILITARY-PISTOL-ACC_W0QQfsubZ8189694^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_22.gif^ alt=^Law Enforcement and Military^ width=^254^ height=^96^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_SECURITY-SELF-DEFENSE_W0QQfsubZ8301045^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_23.gif^ alt=^Security and Self Defense^ width=^254^ height=^93^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_CROSSBOWS-AND-ACCESSORIES_W0QQfsubZ9679282^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_24.gif^ alt=^Crossbows and Accessories^ width=^254^ height=^92^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_CAMPING-BACKPACKING_W0QQfsubZ141941819^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_25.gif^ alt=^Hiking Camping and Backpacking^ width=^254^ height=^80^ border=^0^></a></td> <td colspan=^13^ valign=^top^><br /><div align=^center^ style=^font-size:40px; font-family:Arial, Helvetica, sans-serif;^>] + upper(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(p.ProductName, ',', ' '), 'w/', 'with '), 'ar15', '.233'), 'ar-15', '.233'), 'ar 15', '.223'), 'm4', ''), 'm-4', ''), 'ak47', '7.62x39'), 'ak 47', '7.62x39'), 'ak-47', '7.62x39'), 'assault', '')) + '</div><BR> <div align=^center^><img src=^http://imagehost.vendio.com/a/32017679/view/] + pe.yahoo_category + [ ^ border=^2^ /></div><br /> <div align=^center^ style=^font-size:20px; font-family:Arial, Helvetica, sans-serif;^><p align=^center^>] + pd.ProductDescription + [</p></div><br /><br /> <table border=^0^ cellspacing=^0^ cellpadding=^0^ style=^font-size:16px; font-family:Arial, Helvetica, sans-serif; font-weight:bold;^ align=^center^>INSERTLINKSHERE </table> </td> </tr><tr><td colspan=^19^> </td> </tr><tr><td colspan=^2^> </td> <td colspan=^16^ align=^center^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_28.gif^ width=^60%^ alt=^We only ship to U.S. addresses^></td> <td> </td> </tr><tr><td colspan=^3^> </td> <td colspan=^14^ align=^center^><img src=^http://imagehost.vendio.com/a/32022895/view/Untitled-3_31.gif^ width=^60%^ alt=^We accept the following^></td> <td colspan=^2^> </td> </tr><tr><td colspan=^19^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_33.png^ width=^899^ height=^3^ alt=^^></td></tr><tr><td><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_34.png^ width=^5^ height=^103^ alt=^^></td><td colspan=^18^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_35.gif^ width=^894^ height=^103^ alt=^Questions? Feel free to email us^></td> </tr><tr><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^5^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^97^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^32^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^50^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^41^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^29^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^2^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^44^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^7^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^85^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^20^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^27^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^11^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^109^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^108^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^62^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^51^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^20^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^99^ height=^1^ alt=^^></td></tr></table>] AS "*Description"

ConradK
Posting Yak Master

140 Posts

Posted - 2010-03-16 : 20:29:27

Thats what it looks like, and thats why I didn't post it. The carrots are there because there was a problem with quotes I'de had before, and I was trying to zero the problem out and figured I could find replace afterwards on that end.

As for concatenation in post-product, the idea is to make some code that is fool-proof for the users, and concatenation is something that can get hairy real real quick like.

So thats why I asked it the way I did, and need to do it the way I need to. I appreciate your guys' help!

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2010-03-16 : 21:18:18

First of all, the code is so beautiful

Your problem may be in this part:
<div align=^center^ style=^font-size:40px; font-family:Arial, Helvetica, sans-serif;^>] A + upper(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(p.ProductName, ',', ' '), 'w/', 'with '), 'ar15', '.233'), 'ar-15', '.233'), 'ar 15', '.223'), 'm4', ''), 'm-4', ''), 'ak47', '7.62x39'), 'ak 47', '7.62x39'), 'ak-47', '7.62x39'), 'assault', '')) + '</div>

I think you miss ' in position of the red A above.

Add ' to see if it works

ConradK
Posting Yak Master

140 Posts

Posted - 2010-03-17 : 11:54:36

That did NOT do it...

I'll keep working and reworking it.

You guys don't think its all those =s and /s and other stuff? Its not that the html code is sometimes sql syntax?

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-03-17 : 12:21:58

The [ and ] are your problem. Replace those with single quotes.

ConradK
Posting Yak Master

140 Posts

Posted - 2010-03-17 : 15:43:42

it was so before, i got the same error, thats why I had changed it, but I'll try it!

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2010-03-17 : 15:52:42

Hi ConradK

After you add the ' , you get the same or different error message ?

If different, post the error message here.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-03-17 : 17:25:56

I commented out a couple of the columns for a sample, but hopefully, it makes sense:
DECLARE @Foo TABLE (ProductName VARCHAR(100))
INSERT @Foo
SELECT 'My Produt Name'

SELECT
'<form action=^http://search.stores.ebay.com/search/search.dll?GetResult^ method=^get^ target=^_blank^ name=^search^ id=^search^ style=^DISPLAY: inline; MARGIN-BOTTOM: 0px^><input type=^hidden^ checked=^checked^ value=^n^ name=^srchdesc^ /> <input type=^hidden^ value=^455482329^ name=^sid^ /> <input type=^hidden^ value=^UXSPORTS^ name=^store^ /> <input type=^hidden^ value=^0^ name=^colorid^ /> <input type=^hidden^ value=^0^ name=^fp^ /><table width=^899^ height=^1385^ border=^0^ align=^center^ cellpadding=^0^ cellspacing=^0^ id=^UXSports^ background=^http://imagehost.vendio.com/a/32022895/view/uxsports-bg.png^><tr><td height=^135^ colspan=^14^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_01.gif^ width=^559^ height=^94^ alt=^UXSports^></td><td colspan=^5^> </td> </tr><tr><td height=^49^ colspan=^8^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_03.gif^ width=^300^ height=^49^ alt=^The Best in Sports^></td> <td colspan=^3^> </td> <td colspan=^8^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_05.gif^ width=^487^ height=^49^ alt=^Questions? Give us a call^></td> </tr><tr><td height=^56^ colspan=^5^><a href=^http://stores.shop.ebay.com/UXsports^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_06.gif^ alt=^Our Store^ width=^225^ height=^56^ border=^0^></a></td><td colspan=^8^><a href=^http://feedback.ebay.com/ws/eBayISAPI.dll?ViewFeedback&userid=uxsports&ssPageName=VIP:feedback&ftab=FeedbackAsSeller^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_07.gif^ alt=^Feedback^ width=^225^ height=^56^ border=^0^></a></td> <td colspan=^2^><a href=^mailto:ebay@uxsports.com^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_08.gif^ alt=^Email Us^ width=^217^ height=^56^ border=^0^></a></td> <td colspan=^4^><a href=^http://my.ebay.com/ws/eBayISAPI.dll?AcceptSavedSeller&mode=0&preference=0&sellerid=uxsports^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_09.gif^ alt=^Add Us to Your Favorite Sellers^ width=^232^ height=^56^ border=^0^></a></td> </tr><tr> <td height=^41^ colspan=^4^> <img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_10.gif^ width=^184^ height=^41^ alt=^Search^></td> <td colspan=^6^ background=^http://imagehost.vendio.com/a/32022895/view/uxsports_11.png^ style=^padding-top:9px;^> <input name=^query^ style=^font-family: verdana; color: #000000; font-weight:bold; font-size: 14px;border: thin solid #FFFFFF;^ size=^23^ maxlength=^300^/></td> <td colspan=^2^><input type=^image^ alt=^go^ src=^http://imagehost.vendio.com/a/32022895/view/uxsports_12.gif^ value=^submit^ width=^47^ height=^41^ border=^0^ name=^image^ align=^middle^></td><td colspan=^7^> </td> </tr><tr><td height=^89^ colspan=^7^> <a href=^http://stores.ebay.com/UXsports_FITNESS-ITEMS_W0QQfsubZ8324478^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_14.gif^ alt=^Fitness Items^ width=^256^ height=^89^ border=^0^></a></td><td colspan=^2^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_15.png^ width=^51^ height=^89^ alt=^^></td><td colspan=^7^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_16.gif^ width=^422^ height=^89^ alt=^Most orders shipped by 3:00 PM^></td> <td colspan=^3^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_17.png^ width=^170^ height=^89^ alt=^^></td></tr><tr><td height=^654^ colspan=^6^ valign=^top^><a href=^http://stores.ebay.com/UXsports_PHITEN_W0QQfsubZ131107019^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_18.gif^ alt=^Phiten Items^ width=^254^ height=^106^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_RIFLE-ACCESSORIES_W0QQfsubZ182771119^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_20.gif^ alt=^Rifle Accessories^ width=^254^ height=^93^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_PISTOL-ACCESSORIES_W0QQfsubZ182771219^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_21.gif^ alt=^Pistol Accessories^ width=^254^ height=^94^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_POLICE-MILITARY-PISTOL-ACC_W0QQfsubZ8189694^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_22.gif^ alt=^Law Enforcement and Military^ width=^254^ height=^96^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_SECURITY-SELF-DEFENSE_W0QQfsubZ8301045^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_23.gif^ alt=^Security and Self Defense^ width=^254^ height=^93^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_CROSSBOWS-AND-ACCESSORIES_W0QQfsubZ9679282^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_24.gif^ alt=^Crossbows and Accessories^ width=^254^ height=^92^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_CAMPING-BACKPACKING_W0QQfsubZ141941819^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_25.gif^ alt=^Hiking Camping and Backpacking^ width=^254^ height=^80^ border=^0^></a></td> <td colspan=^13^ valign=^top^><br /><div align=^center^ style=^font-size:40px; font-family:Arial, Helvetica, sans-serif;^>'

+ upper(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(p.ProductName, ',', ' '), 'w/', 'with '), 'ar15', '.233'), 'ar-15', '.233'), 'ar 15', '.223'), 'm4', ''), 'm-4', ''), 'ak47', '7.62x39'), 'ak 47', '7.62x39'), 'ak-47', '7.62x39'), 'assault', ''))

+ '</div><BR> <div align=^center^><img src=^http://imagehost.vendio.com/a/32017679/view/'

--+ pe.yahoo_category

+ '^ border=^2^ /></div><br /> <div align=^center^ style=^font-size:20px; font-family:Arial, Helvetica, sans-serif;^><p
align=^center^>'

--+ pd.ProductDescription

+ '</p></div><br /><br /> <table border=^0^ cellspacing=^0^ cellpadding=^0^ style=^font-size:16px; font-family:Arial, Helvetica, sans-serif; font-weight:bold;^ align=^center^>INSERTLINKSHERE </table> </td> </tr><tr><td colspan=^19^> </td> </tr><tr><td colspan=^2^> </td> <td colspan=^16^ align=^center^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_28.gif^ width=^60%^ alt=^We only ship to U.S. addresses^></td> <td> </td> </tr><tr><td colspan=^3^> </td> <td colspan=^14^ align=^center^><img src=^http://imagehost.vendio.com/a/32022895/view/Untitled-3_31.gif^ width=^60%^ alt=^We accept the following^></td> <td colspan=^2^> </td> </tr><tr><td colspan=^19^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_33.png^ width=^899^ height=^3^ alt=^^></td></tr><tr><td><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_34.png^ width=^5^ height=^103^ alt=^^></td><td colspan=^18^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_35.gif^ width=^894^ height=^103^ alt=^Questions? Feel free to email us^></td> </tr><tr><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^5^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^97^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^32^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^50^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^41^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^29^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^2^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^44^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^7^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^85^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^20^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^27^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^11^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^109^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^108^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^62^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^51^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^20^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^99^ height=^1^ alt=^^></td></tr></table>' AS [*Description]
FROM @Foo AS P

ConradK
Posting Yak Master

140 Posts

Posted - 2010-03-17 : 19:19:43

, '<form action=^http://search.stores.ebay.com/search/search.dll?GetResult^ method=^get^ target=^_blank^ name=^search^ id=^search^ style=^DISPLAY: inline; MARGIN-BOTTOM: 0px^><input type=^hidden^ checked=^checked^ value=^n^ name=^srchdesc^ /> <input type=^hidden^ value=^455482329^ name=^sid^ /> <input type=^hidden^ value=^UXSPORTS^ name=^store^ /> <input type=^hidden^ value=^0^ name=^colorid^ /> <input type=^hidden^ value=^0^ name=^fp^ /><table width=^899^ height=^1385^ border=^0^ align=^center^ cellpadding=^0^ cellspacing=^0^ id=^UXSports^ background=^http://imagehost.vendio.com/a/32022895/view/uxsports-bg.png^><tr><td height=^135^ colspan=^14^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_01.gif^ width=^559^ height=^94^ alt=^UXSports^></td><td colspan=^5^> </td> </tr><tr><td height=^49^ colspan=^8^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_03.gif^ width=^300^ height=^49^ alt=^The Best in Sports^></td> <td colspan=^3^> </td> <td colspan=^8^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_05.gif^ width=^487^ height=^49^ alt=^Questions? Give us a call^></td> </tr><tr><td height=^56^ colspan=^5^><a href=^http://stores.shop.ebay.com/UXsports^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_06.gif^ alt=^Our Store^ width=^225^ height=^56^ border=^0^></a></td><td colspan=^8^><a href=^http://feedback.ebay.com/ws/eBayISAPI.dll?ViewFeedback&userid=uxsports&ssPageName=VIP:feedback&ftab=FeedbackAsSeller^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_07.gif^ alt=^Feedback^ width=^225^ height=^56^ border=^0^></a></td> <td colspan=^2^><a href=^mailto:ebay@uxsports.com^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_08.gif^ alt=^Email Us^ width=^217^ height=^56^ border=^0^></a></td> <td colspan=^4^><a href=^http://my.ebay.com/ws/eBayISAPI.dll?AcceptSavedSeller&mode=0&preference=0&sellerid=uxsports^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_09.gif^ alt=^Add Us to Your Favorite Sellers^ width=^232^ height=^56^ border=^0^></a></td> </tr><tr> <td height=^41^ colspan=^4^> <img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_10.gif^ width=^184^ height=^41^ alt=^Search^></td> <td colspan=^6^ background=^http://imagehost.vendio.com/a/32022895/view/uxsports_11.png^ style=^padding-top:9px;^> <input name=^query^ style=^font-family: verdana; color: #000000; font-weight:bold; font-size: 14px;border: thin solid #FFFFFF;^ size=^23^ maxlength=^300^/></td> <td colspan=^2^><input type=^image^ alt=^go^ src=^http://imagehost.vendio.com/a/32022895/view/uxsports_12.gif^ value=^submit^ width=^47^ height=^41^ border=^0^ name=^image^ align=^middle^></td><td colspan=^7^> </td> </tr><tr><td height=^89^ colspan=^7^> <a href=^http://stores.ebay.com/UXsports_FITNESS-ITEMS_W0QQfsubZ8324478^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_14.gif^ alt=^Fitness Items^ width=^256^ height=^89^ border=^0^></a></td><td colspan=^2^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_15.png^ width=^51^ height=^89^ alt=^^></td><td colspan=^7^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_16.gif^ width=^422^ height=^89^ alt=^Most orders shipped by 3:00 PM^></td> <td colspan=^3^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_17.png^ width=^170^ height=^89^ alt=^^></td></tr><tr><td height=^654^ colspan=^6^ valign=^top^><a href=^http://stores.ebay.com/UXsports_PHITEN_W0QQfsubZ131107019^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_18.gif^ alt=^Phiten Items^ width=^254^ height=^106^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_RIFLE-ACCESSORIES_W0QQfsubZ182771119^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_20.gif^ alt=^Rifle Accessories^ width=^254^ height=^93^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_PISTOL-ACCESSORIES_W0QQfsubZ182771219^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_21.gif^ alt=^Pistol Accessories^ width=^254^ height=^94^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_POLICE-MILITARY-PISTOL-ACC_W0QQfsubZ8189694^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_22.gif^ alt=^Law Enforcement and Military^ width=^254^ height=^96^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_SECURITY-SELF-DEFENSE_W0QQfsubZ8301045^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_23.gif^ alt=^Security and Self Defense^ width=^254^ height=^93^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_CROSSBOWS-AND-ACCESSORIES_W0QQfsubZ9679282^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_24.gif^ alt=^Crossbows and Accessories^ width=^254^ height=^92^ border=^0^></a><br/><a href=^http://stores.ebay.com/UXsports_CAMPING-BACKPACKING_W0QQfsubZ141941819^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_25.gif^ alt=^Hiking Camping and Backpacking^ width=^254^ height=^80^ border=^0^></a></td> <td colspan=^13^ valign=^top^><br /><div align=^center^ style=^font-size:40px; font-family:Arial, Helvetica, sans-serif;^>' + upper(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(p.ProductName, ',', ' '), 'w/', 'with '), 'ar15', '.233'), 'ar-15', '.233'), 'ar 15', '.223'), 'm4', ''), 'm-4', ''), 'ak47', '7.62x39'), 'ak 47', '7.62x39'), 'ak-47', '7.62x39'), 'assault', '')) + '</div><BR> <div align=^center^><img src=^http://imagehost.vendio.com/a/32017679/view/' + pe.yahoo_category + '^ border=^2^ /></div><br /> <div align=^center^ style=^font-size:20px; font-family:Arial, Helvetica, sans-serif;^><p align=^center^>' + REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACe(replace(replace(replace(RePlAcE(cast(pd.ProductDescription as varchar(max)), '"', '""'), CHAR(10) + CHAR(13), ' '), CHAR(10), ' '), CHAR(13), ' '), ',', ' '), 'at myurl.com', ''), 'enjoy free shipping on all orders ever $100', ''), 'enjoy free shipping', ''), 'free shipping', ''), 'on all orders', ''), '!', ''), 'also over $100', ''), 'also over', ''), 'over $100', ''), 'also on orders', ''), 'are now available also', ''), 'now available also', ''), 'myurl.com', ''), '$100', ''), '$', ''), 'on orders', ''), 'ar15', '.233'), 'ar-15', '.233'), 'ar 15', '.223'), 'm4', ''), 'm-4', ''), 'ak47', '7.62x39'), 'ak 47', '7.62x39'), 'ak-47', '7.62x39'), 'assault', ''),'oak', 'zzzoakzzz'), 'eak', 'zzzeakzzz'), 'AK ', 'Russian '), 'zzzoakzzz', 'oak'), 'zzzeakzzz', 'eak'), 'font-size: 12', 'font-size: 14') + '</p></div><br /><br /> <table border=^0^ cellspacing=^0^ cellpadding=^0^ style=^font-size:16px; font-family:Arial, Helvetica, sans-serif; font-weight:bold;^ align=^center^>INSERTLINKSHERE </table> </td> </tr><tr><td colspan=^19^> </td> </tr><tr><td colspan=^2^> </td> <td colspan=^16^ align=^center^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_28.gif^ width=^60%^ alt=^We only ship to U.S. addresses^></td> <td> </td> </tr><tr><td colspan=^3^> </td> <td colspan=^14^ align=^center^><img src=^http://imagehost.vendio.com/a/32022895/view/Untitled-3_31.gif^ width=^60%^ alt=^We accept the following^></td> <td colspan=^2^> </td> </tr><tr><td colspan=^19^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_33.png^ width=^899^ height=^3^ alt=^^></td></tr><tr><td><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_34.png^ width=^5^ height=^103^ alt=^^></td><td colspan=^18^><img src=^http://imagehost.vendio.com/a/32022895/view/uxsports_35.gif^ width=^894^ height=^103^ alt=^Questions? Feel free to email us^></td> </tr><tr><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^5^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^97^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^32^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^50^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^41^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^29^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^2^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^44^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^7^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^85^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^20^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^27^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^11^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^109^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^108^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^62^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^51^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^20^ height=^1^ alt=^^></td><td><img src=^http://imagehost.vendio.com/a/32022895/view/spacer.gif^ width=^99^ height=^1^ alt=^^></td></tr></table>' AS [*Description]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources