serios problem with sql command

Hershel Fisch hershrev at realtorsgroup.us
Wed Nov 9 18:58:44 EST 2005


On 11/3/05 8:35 AM, "Alessandro Pisoni" <alessandro at system-ini.it> wrote:

Looks like u r missing the "'" surrounding the values.
Hershel
> 
> Bye i have an serios problem with the command revExecuteSQL !!! not
> work into my db sql.
> 
> get revOpenDatabase
> ("MySQL","localhost","Gestionale","alessandropisoni","") //
> alessandropisoni is administrator fullcontrol
> revExecuteSQL it,"INSERT INTO Anagrafica (id, Codice) values (NULL,
> 22)" // not write in my db and in my table why?
> 
> i use now mysql 5 server and mac os x 10.4.3
> I can to do the command sql SELECT and the command   get
> revQueryDatabase(it,"SELECT * FROM Anagrafica") work ok very well!
> 
> 
> Cordiali saluti
> Alessandro Pisoni
> 
> ======================
> System.ini
> Via Grandi 5
> 20062 Cassano d'Adda (MI)
> Tel. 0363-361487 Fax 1782260060 Cell. 335-440150
> URL: www.system-ini.it   email: Info at system-ini.it
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the use-livecode mailing list