Truncate output from SQL 2

[Kozimoto]

Hello.

I have an ASP/Javascript results page with output from an nvarchar field in SQL. I need to truncate the output to a predetermined number of characters followed by (...). I found one post using:

<%=LEFT(SearchResults.Fields.Item("entry_content").Value).Value,100)%>

but I receive a 500 error using this code and assume this code works with Access and not SQL.

Any suggestions would be appreciated. Thanks in advance.

 

[ChrisHirst]

How about this, thread333-882989

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[Kozimoto]

Hey Chris thanks for the reply. I was hoping for something a little more Dreamweaver code centric. Or an explanation as to why the code sample I picked up in another DW post worked for them and not for me.

I appreciate your ASP thread through. if all else fails I'll see what I can do with a little hand coding.

 

[Cheech]

Have a look at the Macromedia site for an extension called Truncate It

http://www.macromedia.com/cfusion/e...=1004221&viewName=Dreamweaver Extension&avm=1

That will add an extension which is easy to configure

Cheech

[Peace][Pipe]

 

[Kozimoto]

Thanks Cheech. Truncate-IT is ASP/VBscript only. I've also checked out Crop Sentence too.

Any other ideas?

 

[Cheech]

Have a look at this then

http://www.w3schools.com/js/tryit.asp?filename=tryjs_substr

[Peace][Pipe]

 

[Kozimoto]

That looks interesting Cheech. I'm not sure how I would code the DW string that returns the text from my nvarchar field into this code. My code looks just like the code in my first post in this thread.

 

[Cheech]

<script>
var str = "<%=SearchResults.Fields.Item("entry_content").Value%>
document.write(str.substr(0,100))
</script>

or something like that

Cheech


[Peace][Pipe]

 

[Kozimoto]

Hi Cheech. Thanks for all your efforts on this post. I've scoured the web looking for a solution. Truncate It works great, but I'm knee deep in setting up this site in Javascript. Your suggestions look like the best option so far, but I would also need the script to not cut off in the middle of a word followed by (...read more) I'll keep looking.

 

[ChrisHirst]

Can't resist this, but wouldn't spending about 5 mins learning how to use

var str = "<%=GetSnippet(SearchResults.Fields.Item("entry_content").Value,100)%>

been simpler than 2 days of firing questions back and forth?



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.