Jump to content

PhDJ

Members
  • Posts

    6
  • Joined

  • Last visited

Everything posted by PhDJ

  1. That works, thanks justsomeguy !
  2. When I execute the following SQL statement : select IT.ITEMID, IT.ITEMNAME, IT.ITEMNAMEFR, IT.ITEMSTRUCT, IT.ITEMSTRUCT2_, IT.ITEMSTRUCT3_, IT.ITEMSTRUCT4_, IT.ITEMSTRUCT5_, IT.ITEMSTRUCT6_, ist5.DESCRIPTIONFRBE, ist5.DESCRIPTIONNLBE, ist5.DESCRIPTIONENGB, ist5.DESCRIPTIONDE, ist6.DESCRIPTIONFRBE, ist6.DESCRIPTIONNLBE, ist6.DESCRIPTIONENGB, ist6.DESCRIPTIONDE from InventTable as it join itemStructTable as ist5 on ist5.structLevelType = '5' and ist5.structLevelID = it.itemStruct5_ join itemStructTable as ist6 on ist6.structLevelType = '6' and ist6.structLevelID = it.itemStruct6_ When I print the result of the array ( via print_r(mssql_fetch_array($this->recordSet, 'MSSQL_BOTH) , the recordset is set as follows : $this->recordSet = mssql_query($sqlStatement, $this->connection); ), I get the following result : Array ( [iTEMID] => 31-0030-0347 [iTEMNAME] => Rubberdoeken Ruby UV 1,70 : 330 x 1000 mm [iTEMNAMEFR] => Blanchets Ruby UV 1,70 : 330 x 1000 mm [iTEMSTRUCT] => T [iTEMSTRUCT2_] => 31 [iTEMSTRUCT3_] => 3100 [iTEMSTRUCT4_] => 310030 [iTEMSTRUCT5_] => 310030100 [iTEMSTRUCT6_] => 310095 [DESCRIPTIONFRBE] => Ruby UV 1,70 [DESCRIPTIONNLBE] => Ruby UV 1,70 [DESCRIPTIONENGB] => Ruby UV 1,70 [DESCRIPTIONDE] => Ruby UV 1,70 ) The prefixes for the table names are not present, so I only get one set of descriptions instead of two. Is there a way to force PHP or MSSQL to give me the exact fieldnames I used in my select ?
  3. PhDJ

    REST JSON tutorial

    It seems I was not the only one wondering about the server side of things : Dr. M. Elkstein said... Hello James, Indeed, I have written little about the server-side part of REST, seeing that it is no different than "regular" web serving (except that the output is to be consumed by machines, not people). I see now that more and more people ask for this extension, and I plan to write about it in the (hopefully near) future. December 6, 2009 9:08 PM Seems like he never got around to it ...
  4. PhDJ

    REST JSON tutorial

    It has everything on how to use REST, not on how to build your own REST server.
  5. PhDJ

    REST JSON tutorial

    Thanks for that Birbal ! Any suggestions on example code to get a REST service running ?
  6. PhDJ

    REST JSON tutorial

    Can anyone guide me to a good tutorial or explanation on how to use REST webservices in combination with JSON. Both are new to me.
×
×
  • Create New...