php - Run queries to MS SQL server with strange table names -

-

for application need connect sql server 2008 queries.

i run queries in php on codeigniter framework. access sql database program called "microsoft sql server management studio". tables have strange names dollar signs: trp$lease car example.

the studio data query:

select top 1000 *   [mdatabase].[dbo].[trp$lease car]

when run query in php installation fails on $ sign:

$data = $this->db->query("select * dbo.trp$lease car");

like this:

a php error encountered

severity: notice

message: undefined variable: lease

filename: views/welcome_message.php

line number: 5 database error occurred

error number: 42s02

[microsoft][sql server native client 11.0][sql server]invalid object name 'dbo.trp'.

how need call these tables when running query php?

edit

the problem appears on tables space in name... query trp$invoice works. in case trp$lease car problem think..

this due fact have query in double-quotes. when php encounters double-quoted string containing $something, treat $something variable , attempt substitute value. in case, have tpr$lease in string - php attempts resolve variable $lease - haven't defined - , gives warning message indicated. there 2 ways of dealing it.

  1. escape dollar sign: "select * tpr\$lease" - telling php need dollar sign there.

  2. use single-quoted string: 'select * tpr$lease' - php not variable substitution in single-quoted strings.

obviously, adjust actual sql statements according specific schema.

edit: if table name contains spaces, have use square brackets [ ... ] around tabla name:

"select * [tpr\$lease car]"

note ms sql specific syntax. not work on other database engines, (to knowledge) ms allows spaces in table names.


Comments

Post a Comment

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

-
i used pyinstaller create standalone exe file pyqt project. did not use single file option because exe created single file option takes long open. therefore, pyinstaller created dist folder contains bunch of files including program.exe file. create setup.exe file place contents of dist folder in program directory , create shortcut in start menu , on desktop. want super simple user. maybe setup.exe files when download program cnet. found inno-setup, looks promising. however, not know if there special considerations because program standalone program create python/pyqt program. thanks! have experience task? there program using task not know about? inno-setup or nsis easiest use. tell them files include , put them , create nice installer you. wrote short tutorial on experiences using innosetup might find helpful: http://www.blog.pythonlibrary.org/2008/08/27/packaging-wxpymail-for-distribution/ note tutorial based around wxpython app wrote, concepts same.
Read more

c# - Access objects in UserControl from MainWindow in WPF -

-
i have simple xaml, how can change text property of textblock in usercontrol1 mainwindow ? <window x:class="refactorxaml.mainwindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:refactorxaml="clr-namespace:refactorxaml" title="mainwindow" height="350" width="525"> <grid> <grid.rowdefinitions> <rowdefinition height="100"></rowdefinition> <rowdefinition height="100"></rowdefinition> </grid.rowdefinitions> <grid> <refactorxaml:usercontrol1></refactorxaml:usercontrol1> </grid> <grid grid.row="1"> <button>change text</button> </grid> </grid> </window> <usercon...
Read more

javascript - How to name a jQuery function to make a browser's back button work? -

-
i'm trying write function ajaxyfy web site, works perfect, except function button. that's have now: function loading() { if (typeof history.pushstate !== "undefined") { var historycount = 0; $('.menu-item, .logo').on('click','a',function(e){ e.preventdefault(); $(this).data('clicked', true); if ($(this).is('.logo a')) { var homepage = $(this).attr('href'); function1(homepage); history.pushstate(null, null, homepage); } else if ($(this).is('.projects a')) { var projects = $(this).attr('href'); function2(projects); history.pushstate(null, null, projects); } else { var pages = $(this).attr('href'); function3(pages); history.pushstate(null, null, pages); ...
Read more