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
