Hi all, I'm using delphi 7 with MySql, and make my sql statements with parameters facility. When I assign a string to a parameter with AsString option, it puts me the character ' before and after my string that is to be inserted, and the Mysql interpreter ignores that string resulting a bad dataset returned. How can I avoid these ' characters?
E.g. SELECT * FROM table ORDER BY :prm which gives me SELECT * FROM table ORDER BY 'realprm' Sincerely Adrian ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/

