you can't use a parameter to subsitute for a column name. In normal usage, the string quotes are desirable. You should generate the SQL string on the fly, concatenating in the column name.
DJS --- tarniadi <[EMAIL PROTECTED]> wrote: > 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 > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
