projects
/
infodrom.org
/
service.infodrom.org
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(from parent 1:
fcb9ace
)
Cast required
author
Joey Schulze
<joey@infodrom.org>
Sun, 6 Jul 2008 21:08:01 +0000
(21:08 +0000)
committer
Joey Schulze
<joey@infodrom.org>
Sun, 6 Jul 2008 21:08:01 +0000
(21:08 +0000)
src/InfoCon/account/query.wml
patch
|
blob
|
history
diff --git
a/src/InfoCon/account/query.wml
b/src/InfoCon/account/query.wml
index
bc61e7d
..
a1fe496
100644
(file)
--- a/
src/InfoCon/account/query.wml
+++ b/
src/InfoCon/account/query.wml
@@
-75,7
+75,7
@@
input.submit:hover {
<select id=year name=year>
<option>
<?
- $query = "SELECT DISTINCT substr(datum,0,5) AS year FROM $table ORDER BY year DESC";
+ $query = "SELECT DISTINCT substr(datum
::text
,0,5) AS year FROM $table ORDER BY year DESC";
$sth = pg_exec ($dbh, $query);
for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {