Re: mysqlgui, ?var? and quotes
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 ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: mysqlgui, ?var? and quotes
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
mysqlgui, ?var? and quotes
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? - 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