Sinisa Milivojevic wrote: >Jean.Maupertuis writes: > >>I try to use the ?var?'s to create a menu for inserting new rows in a table. >>for example: >>insert into personnel(first_name, last_name) values(?first_name?, >>?last_name?) >>if i type jean in first_name and maupertuis in last_name the result is >>"unknow column >>'jean' in 'field list' "because it's translated >>insert into personnel(first_name, last_name) values (jean,maupertuis) >>to correct i have to type 'jean' and 'maupertuis' this is tranlated >>insert into personnel(first_name, last_name) values('jean','maupertuis') >>which is the correct form. >> >>We can test this with a little sql: >>select ucase(?test?) >> >>I try different things to solve : concat, '?var?', ... but i don't find >>a way to bypass. >> >>Have anyone a better solution? >> > > >Just use quotes when inserting values. > >I could (when I find time), do it automatically if column is >char/varchar/text/blob ... > >Would that solve your problem ?? > > Yes , it solves but it's not friendly to tell a user to insert quotes. So, i totally agrre with your proposal to do it automatically (when you have time). Please put a message on the list when you have done. Thanks
Jean --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php