Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) 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
 
Old February 6th, 2006, 03:51 PM
Authorized User
 
Join Date: Jan 2005
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default formatting memo fields in access database


Hello Imar and everyone else!

I use Dreamweaver´s ability to insert and update (memo) fields to/from an Access 2003 database successfully.

My problem: the user would like to put some words in bold (like I did here) or in color (2 or 3 options) , the text must be updated in Access with "something" to make it "remember" its characteristics. Then, when the text is extracted from the db to be seen in his monitor, from a recordset, the user should see the same words in bold and/or different colors.

Got the picture? Please give hints on how to proceed.

When the user clicks an image with "bold" written in it, should I put "[ " b "]" before and "[" / b "]" after the word? When this is saved and retrieved, will the Dreaweaver asp-page understand what this means and show it in bold characters? Is this the path to the solution?

Thanks a lot,
fskilnik



 
Old February 6th, 2006, 04:39 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I don't think Dreamweaver has much to do with this.

What you're describing here is a common Content Management System (CMS) requirement. To offer the user the ability to format text, a few solutions are available. One is to use UBB code which is used on this Wrox site. Users enter stuff like "[" b "]" in a text area (possibly through a tool bar) and when the page is displayed, some replacement code (using Regular Expressions for example) replaces the UBB tags with proper HTML tags.

Another alternative is to offer your users a WYSIWYG editor. One editor I like a lot is the FCKeditor at www.fckeditor.com . This editor stores HTML in a hidden field which can then be stored in the database or displayed on another page. Note that the actual HTML is then stored in a database....

Since both the FCKeditor and this forum are released as open source, I suggest you check them out and see if you like them. The FCKeditor is really simple to implement in ASP pages. Don't know how easy it is to use the Snitz forum....

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old February 6th, 2006, 05:06 PM
Authorized User
 
Join Date: Jan 2005
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello, Imar! Thanks for the very quick reply.

>I don't think Dreamweaver has much to do with this.

Sorry for that. You´re 100% right, of course, but the possibility of receiving your expert advice is THE reason I´ve put the question here. (It worked :) !)

I have checked this FCKeditor. Simply great! Exactly what I needed. (More than that, to be honest.)

Great advice. Thanks a lot. I will try to put it to work for me.


Best regards,
fskilnik.





 
Old February 7th, 2006, 03:12 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You're welcome...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old February 9th, 2006, 04:58 PM
Authorized User
 
Join Date: Jan 2005
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default


Hi there, Imar!

FCKeditor feedback: VERY GOOD product, no doubt! With very little (ASP) coding I could put it to work for me. Really impressive. Great experience. Thanks a lot for the suggestion.

Cheers,
Fábio.


 
Old February 9th, 2006, 06:17 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Great. I am glad you like it.

Ever since I discovered it, I have been using it in all my projects that needed an editor, including some of the chapters in my upcoming book.

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: When It Comes by Incubus (Track 5 from the album: Make Yourself) What's This?
 
Old February 10th, 2006, 10:45 AM
Authorized User
 
Join Date: Jan 2005
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Nice to hear that, Imar!

By the way... please tell us (your grateful readers) something about it: title, content, etc.

I guess I will not be the only serious candidate for buying it, for sure! :)

Best regards and all the best with this new book,
Fábio.


Obs.: for other readers of this forum: if you don´t know Imar´s (et al) "Beginning Dreamweaver MX 2004" wrox book (ISBN 7645-5524-3) , you didn´t have the opportunity to see "a master in his trade". There are 3 projects there, the first one very simple but important as first "basic" contact with the whole suite, the second one simply EXCELLENT (yes, done by our dear Mr. Imar Spaanjaars himself!) and the third, well, to be honest, I never started it.

It seems to me that all the real stuff is in the second project and, frankly, Imar´s ability to mix Dreamweaver´s automatically smart (but long and too abstract) coding creation with his hands-on "write-your-own" ASP and Javascripts parts is really amazing. Now I feel more than confident to stop "leaving" for Dreamweaver the "hard stuff" (coding) and doing it myself (with one or two ASP and ASP.NET aditional books for support, sure).

P.S.1: yes, I know this is propaganda to Imar´s present (and perhaps future book) and... he deserves it.

P.S.2: yes, I am grateful for many EXPERT advice, corrections and helps he had already given me, absolutely for free, as he does for all of you, other readers. But... his book is great without taking this into account. Period.

P.S.3: I don´t have any sort of money agreements with him. No, I am not gay, neither. (Laugh) I am 35 years, married, two kids and lived long enough to buy many stupid books, from authors that give only silly cookbook-recipes as their readers couldn´t think for themselves. Imar respect his readers. I respect him.

P.S.4: you owe me a cup of coffee after all this, Imar. Ok?! ;)





 
Old February 10th, 2006, 03:45 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

*** is blushing *** ;)

Since a few days, the book is up at the Wrox site, and is now located here: http://www.wrox.com/WileyCDA/WroxTit...471749516.html

It should be out by March 20 (according to Amazon, that is...)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old February 14th, 2006, 06:24 PM
Authorized User
 
Join Date: Jan 2005
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Great, Imar. Thanks!

Regards,
fskilnik





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access database fields with SQLDataSource hastikeyvan ASP.NET 3.5 Basics 0 April 21st, 2008 01:10 AM
Need help in exporting memo fields to CSV file Programming_starter C# 0 May 22nd, 2006 11:25 AM
Storing Data in Memo Fields! tks_muthu Classic ASP Databases 2 April 11th, 2005 02:07 AM
Memo Fields with Windows Forms in C# jim.stanley Access 0 November 15th, 2004 05:55 PM
Memo fields takabyte Classic ASP Basics 2 October 31st, 2003 06:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.