Use quotedstr(realprm) mike
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of tarniadi Sent: Friday, 7 October 2005 2:56 AM To: [email protected] Subject: [delphi-en] ' character in a string created with parameters 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 ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links ------------------------ 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/
