*** 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 |
dregad | in-line if is not very portable, it would probably be better to use a case statement | 02:09 |
dregad | but if it's for your own personal use, i guess that would work | 02: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 supported | 03: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 | |
dregad | this has nothing to do with PHP - it's SQL | 05: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 types | 07:07 |
BD- | i checked the core\database_api class and browsed through the library\adodb files, but couln't easily find such a syntax description | 07:09 |
BD- | so i don't know which sql is 'understood' and translatable to all underlaying database types and which isn't | 07: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!