php - mssql_query weird behaviour : automatically removes double-quotes around column value (and the column type is "integer")? -


i can´t find explanation behaviour (sql server 2008 + php 5.2.14)

-this piece of code works ok:

$query=' select id news..news id="727" '; $conn=mssql_connect("myddbbserver","user","password"); $idquery=mssql_query($query); $row=mssql_fetch_array($idquery); echo $row[0]

i have id int typed column, if copy , paste query on sql server query console, following error: "the column name '727' not valid".

i have no idea why working via mssql_query, seems php_mssql driver removing double quotes... i´m sure has php_mssql driver , not other php.ini property, because if execute query using php_sqlsrv driver same error through sql server query console ("column name not valid").

any appreciated.

see set quoted_identifier in books online. when it's set on double quotes interpreted marking identifier; when it's off double quotes mark literal value. odbc , ole db set on default, different libraries can , can set explicitly if need to.

the bigger picture shouldn't embedding literal values in sql anyway. instead, should using parameterized queries (however work in particular client library) because avoids issues sql injection, quoting , data type conversion.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more