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
