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
mysqlgui
hi in the help file of mysqlgui we find that it has the functions for: - Generating a menu with table fields based on tables that the user has choosen - Parametrized queries, where the user can put any number of ?var? strings and getting a dialog with all ?var? specified, so that inputed values replace ?var? s before execution How these 2 functions work? I try Commands --- Table Choose table next Commands Table - Edit Table But nothing happen Thanks for your help Jean Maupertuis - 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
