Suggested means to cope with commas etc.

G'day,
In a typical 'contact us' type page what is a recommended way to ensure a message text box gets dealt with properly rather than break at comma's etc.

Is it as simple as using server.encodeHTML() on every passed variable? When I do this I still seem to have problems.

GeoffWhy would you break at commas? I don't get the problem.
Sorry. Error was happening when writing a record of the email to a database.

So if I can change my question...

Is there a best-practice' approach to handling commas etc. when writing to database eg:..."insert into myTable message = '" & server.encodeHTML(msg.text) & "'" is the sort of thing that was breaking if a comma existed in the textbox called msg?

Thanks,

Geoff
The commas should not mess it up within the quotes.

If an apostrophe appears within the string ('), then it will close the string and this is what will mess it up.

The best practice is to use Parameters. These will take care of all these issues as well as protect you against SQL injection and a few other problems you may not have noticed yet.

suggestions for places to aquire free / standard icons?

I have a need to use a variety of icons, which are typical ones, calendars, email, notepads, etc. I have found some nice ones but they usually end up costing some money. Looking for any good sites or microsoft based resources for icon images.

Any help is appreciated.

Thank you

Keeper-

Far and away the best site I have ever found for high quality icons at an incredible price (less than $90) is Icon Drawer (http://www.icondrawer.com/buy.php).Eugen Buzuk is an incredible designer and his icons make all of the other free icon resources I've seen look like cheap trash. Take a look at his collections. I think you'll be impressed.

Hope that helps.

-Todd

http://commons.wikimedia.org/wiki/Crystal_Clear

there ya go buddy

I useIcon Archive

There is a icons community for asp.net, check it below

http://www.aspneticons.com/

HC

Todd you owe me some money. I was just browsing the forums not looking for anything particular and I spent almost $200 on icons I probably don't need. You were right these are amazing.

Bart

Bart-

I'm glad you like them. You'll get your money's worth out of them. Trust me. :)

-Todd

Thank you all for the wonderful feedback. Provided me with execellent options.

Keeper-

I'm glad you found these suggestions helpful. I'm sure you'll find some great icons for your app.

Don't forget to mark any of the posts in this thread that you found helpful as "Answer" so that others that come behind you know where to look for help (and it also let's other experts know this question is complete).

Good luck on the rest of your project.

-Todd