[Gambas Bug Tracker] Bug #1109: Wrong Substitution

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1109: Wrong Substitution

bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1109&from=L21haW4-

Michael ALTROGGE reported a new bug.

Summary
-------

Wrong Substitution

Type             : Bug
Priority         : Medium
Gambas version   : 3.9.90 (TRUNK)
Product          : PostgreSQL driver


Description
-----------

Doing this:

Public Sub MAIN()
    Dim strSQL As String
    DatabaseOpenCon()
-->    strSQL = DBConMain.Subst("SELECT &1, &2, &3, &4, &5, &6 FROM &7", "INDX", "MNDT", "SQLT", "SQLI", "SQLB", "SQLN", "DD00T")
    DBErgMain = DBConMain.Exec(strSQL)
    For Each DBErgMain
        Debug DBErgMain[0], DBErgMain[1], DBErgMain[2], DBErgMain[3], DBErgMain[4], DBErgMain[5]
    Next
End

will result in that:

--> SYS_DB.MAIN.10: SELECT E'INDX', E'MNDT', E'SQLT', E'SQLI', E'SQLB', E'SQLN' FROM E'DD00T'


System information
------------------

[System]
Gambas=3.9.90
OperatingSystem=Linux
Kernel=4.4.0-72-generic
Architecture=x86_64
Distribution=Linux Mint 18.1 Serena
Desktop=CINNAMON
Theme=Gtk
Language=de_DE.UTF-8
Memory=3511M

[Libraries]
Cairo=libcairo.so.2.11400.6
Curl=libcurl.so.4.4.0
DBus=libdbus-1.so.3.14.6
GStreamer=libgstreamer-0.10.so.0.30.0
GStreamer=libgstreamer-1.0.so.0.803.0
GTK+2=libgtk-x11-2.0.so.0.2400.30
GTK+3=libgtk-3.so.0.1800.9
OpenGL=libGL.so.1.2.0
Poppler=libpoppler.so.58.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.5.1
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-EFHGqAGhVd,guid=9b762d3834ba788f5de4cc2b5926db76
DEFAULTS_PATH=/usr/share/gconf/cinnamon.default.path
DESKTOP_AUTOSTART_ID=107b3a8f22f976950d149571877581630100000020170012
DESKTOP_SESSION=cinnamon
DISPLAY=:0
GB_GUI=gb.qt4
GDMSESSION=cinnamon
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GTK_MODULES=gail:atk-bridge
GTK_OVERLAY_SCROLLING=1
HOME=<home>
LANG=de_DE.UTF-8
LOGNAME=<user>
MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path
MDMSESSION=cinnamon
MDM_LANG=de_DE.UTF-8
MDM_XSERVER_LOCATION=local
PATH=<home>/bin:<home>/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
PWD=<home>
QT_ACCESSIBILITY=1
QT_LINUX_ACCESSIBILITY_ALWAYS_ON=1
QT_QPA_PLATFORMTHEME=qgnomeplatform
QT_STYLE_OVERRIDE=gtk
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/2017,unix/<hostname>:/tmp/.ICE-unix/2017
SHELL=/bin/bash
SSH_AGENT_PID=2101
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=7
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-cinnamon:/etc/xdg
XDG_CURRENT_DESKTOP=X-Cinnamon
XDG_DATA_DIRS=/usr/share/cinnamon:/usr/share/gnome:/usr/local/share/:/usr/share/:/usr/share/mdm/
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SESSION_COOKIE=5ab3c275b7304ed3b8aeef9ffcc37eb4-1495718772.950534-1270231686
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c1
XDG_VTNR=7



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1109: Wrong Substitution

bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1109&from=L21haW4-

Comment #1 by Benoît MINISINI:

The Connection.Subst() method is for quoting SQL values. To quote SQL table or fields, you must use the Connection.Quote() method.

Benoît MINISINI changed the state of the bug to: Rejected.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Loading...