AW: [Gambas-user] problem with "&" and mysql

[Charlie Reinl]

>Matthias Laur schrieb:
>> Hi Andreas,
>> can you insert the statement with '&' in the mysql table from an other
>> interface without gambas. Maybe it is a mysql problem.
>>
>> If you use Gambas 1.0.3 I would update at first. The newest stable is
>> 1.0.14.
>>
>> Regards,
>> Matthis
------snip
>>
>> Yes, if theres no Value wich includes an "&" it will work.
>>
>in PHP-MyAdmin it will work. It's only a problem with gambas.
>
>--
>Mit freundlichen Grüßen aus Onsabrück.
>
>Andreas Fröhlke
>
Salut ,

PUBLIC SUB btnOK_Click()
DIM rTest AS Result
    meConn.Handle.Begin
    IF sWhat <> "EDIT" THEN
        rTest = meConn.Handle.Create("crm_Customers")
        rTest!guid = Main.UUID.getUUID()
        rTest!mandnr = Main.sysMandNr
    ELSE
        rTest = meConn.Handle.Edit("crm_Customers", "guid = &1", sGUID)
    ENDIF
    rTest!id = TextBox7.Text
    rTest!mcode = TextBox8.Text
    rTest!fon = TextBox9.Text
    rTest!mail = TextBox10.Text
    rTest!name1 = TextBox11.Text
    rTest!city = TextBox12.Text
    rTest.Update
    meConn.Handle.Commit
     ME.Close(TRUE)
CATCH
    message.Warning(Replace(Error.Text, ".", "." & gb.NewLine))
END

with the upper Code the &, on my box finshed in the Database.

This is my Box:
----------------- gambas
----------------------------------------------------------------
gbx-1.0.14
/usr/bin/gbx
----------------- gambas2
----------------------------------------------------------------
gbx2-1.9.24
/usr/local/bin/gbx2
----------------- X
--------------------------------------------------------------------

X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: Linux 2.6.8-gentoo-r3 i686 [ELF]
Current Operating System: Linux gentoo01 2.6.14-gentoo-r5 #1 SMP PREEMPT
Sun Jan 29 23:42:07 CET 2006 i686
Build Date: 29 December 2005
	Before reporting problems, check http://wiki.X.Org
	to make sure that you have the latest version.
Module Loader present
----------------- kernel
----------------------------------------------------------------
Linux gentoo01 2.6.14-gentoo-r5 #1 SMP PREEMPT Sun Jan 29 23:42:07 CET
2006 i686 AMD Athlon(tm) MP AuthenticAMD GNU/Linux
----------------- Release
--------------------------------------------------------------
Gentoo Base System version 1.6.14
----------------- QT and KDE
------------------------------------------------------------
Qt: 3.3.4
KDE: 3.4.3
KDE Daemon: $Id: kded.cpp 380816 2005-01-21 15:36:26Z waba $
----------------- gcc
--------------------------------------------------------------------
gcc (GCC) 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8)
Copyright © 2003 Free Software Foundation, Inc.
Dies ist freie Software; die Kopierbedingungen stehen in den Quellen. Es
gibt KEINE Garantie; auch nicht für VERKAUFBARKEIT oder FÜR SPEZIELLE
ZWECKE.

----------------- make
----------------------------------------------------------------
GNU Make 3.80
Copyright (C) 2002  Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
----------------- autoconf
----------------------------------------------------------------
autoconf (GNU Autoconf) 2.59
Written by David J. MacKenzie and Akim Demaille.

Copyright (C) 2003 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO

warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.
----------------- automake
----------------------------------------------------------------
automake (GNU automake) 1.9.6
Written by Tom Tromey <tromey at ...34...>.

Copyright 2005 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO

warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.
----------------- mySql
----------------------------------------------------------------
mysql  Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 5.0

----------------- PostgreSQL
------------------------------------------------------------
psql (PostgreSQL) 8.0.4
enthält Unterstützung für Kommandozeilenbearbeitung
----------------- SQLite
----------------------------------------------------------------
2.8.15
----------------- SQLite3
----------------------------------------------------------------
3.2.1

Try the attached script, all what you see below about my box was written
by that script

Amicalment
Charlie
* Gesendet mit / Sent by: FEN-Webmail * http://www.fen-net.de *
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sysInfo.sh
Type: application/x-shellscript
Size: 2721 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20060210/896273b0/attachment.bin>