Friday, 2012-06-29

*** Joins: dhx1 (~anonymous@60-242-247-232.static.tpgi.com.au)00:23
*** Quits: dhx1 (~anonymous@60-242-247-232.static.tpgi.com.au) (Client Quit)00:25
*** Joins: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net)00:52
*** Quits: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net) (Quit: Quit)01:23
*** Joins: dregad (~dregad@155.250.128.35)01:25
*** Joins: BD- (5576d197@gateway/web/freenode/ip.85.118.209.151)01:52
BD-can i use an "if" clause in sql statements i write ?01:53
BD-like "ORDER BY handler_id, if(b.due_date = 1, 9999999999, b.due_date), weight DESC"01:54
dregadin-line if is not very portable, it would probably be better to use a case statement02:09
dregadbut if it's for your own personal use, i guess that would work02:09
*** Joins: asm89 (~asm89@unaffiliated/asm89)02:32
BD-case will port to all supported database types ?02:38
BD-i search but i couldn't find documentation about which syntax is supported03:53
BD-searched*03:53
BD-or am i asking a stupid question :( i'm not experienced at php :)04:02
*** Quits: dregad (~dregad@155.250.128.35) (Remote host closed the connection)05:11
*** Joins: dregad (~dregad@155.250.128.35)05:11
*** Quits: dregad (~dregad@155.250.128.35) (Remote host closed the connection)05:12
*** Joins: dregad (~dregad@155.250.128.35)05:12
*** Parts: dregad (~dregad@155.250.128.35) ()05:12
*** Joins: dregad (~dregad@155.250.128.35)05:12
dregadthis has nothing to do with PHP - it's SQL05:15
*** Quits: kirillka (~Miranda@195.242.142.17) (Remote host closed the connection)05:29
*** Joins: kirillka (~Miranda@195.242.142.17)05:30
BD-but in order to support multiple types of databases, don't you need some sort of data access framework & libraries - which translate a given sql string into the database-specific language variant ?07:07
BD-i'd expect such a framework to define the supported syntax which can be translated into all database types07:07
BD-i checked the core\database_api class and browsed through the library\adodb files, but couln't easily find such a syntax description07:09
BD-so i don't know which sql is 'understood' and translatable to all underlaying database types and which isn't07:09
*** Joins: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net)07:51
*** Joins: Protogenes (~Protogene@cmnz-4db36497.pool.mediaWays.net)07:57
*** Quits: BD- (5576d197@gateway/web/freenode/ip.85.118.209.151) (Quit: Page closed)07:59
*** Quits: asm89 (~asm89@unaffiliated/asm89) (Quit: bye!)08:31
*** Quits: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net) (Remote host closed the connection)08:35
*** Joins: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net)08:49
*** Quits: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net) (Remote host closed the connection)09:05
*** Joins: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net)09:46
*** Joins: paulr (~IceChat09@cpc1-enfi15-2-0-cust580.hari.cable.virginmedia.com)10:19
*** Joins: souliaq_ (c81fd61b@gateway/web/freenode/ip.200.31.214.27)11:40
souliaq_I create a new user, what is the default password?11:41
*** Quits: souliaq_ (c81fd61b@gateway/web/freenode/ip.200.31.214.27) (Quit: Page closed)11:52
*** Quits: echo083 (~adam@mna75-11-88-161-199-126.fbx.proxad.net) (Quit: Quit)12:16
*** Quits: sdfjkljkdfsljkl (~sdfjkljkd@static.96.23.63.178.clients.your-server.de) (Remote host closed the connection)17:00
*** Joins: sdfjkljkdfsljkl (~sdfjkljkd@static.96.23.63.178.clients.your-server.de)17:00
*** Quits: paulr (~IceChat09@cpc1-enfi15-2-0-cust580.hari.cable.virginmedia.com) (Quit: If your not living on the edge, you're taking up too much space)17:29

Generated by irclog2html.py 2.10.0 by Marius Gedminas - find it at mg.pov.lt!