Hi
I am using jQuery in my site which I am currently developing, I have used it on many pages within my site, including a nice jQuery calculator. You can see an example of the image cycle jQuery on the left and on the right column of the home page:
http://www.seemalta.net Basically, I used the text/html module, I inserted the links to my jQuery in the module head section and the html jquery body into the "source" section of my text/html module. However, I recommend that you use the latest jQuery (1.2 version or above) you can as it contains coding to prevent a clash of the $ symbol, which is also used in the DNN core coding. Or if you are using jQuery version 1.1 you should replace the $ with "jQuery" in your jquery code.
I hope that helps.
I have promised Lee that I will submit an artical on using jQuery with DNN in the very near future. I hope to make a start on it soon (when my replacement laptop arrives) and I can get back to normal and no longer need to use this old steam engine of a computer.
Thanks
Lynn