From fc2c4118c67ce52c0c758056d76eb86b3ffa1200 Mon Sep 17 00:00:00 2001 From: wbudic Date: Thu, 17 Jan 2019 16:12:31 +1100 Subject: [PATCH] DB select ordering fixed, minor. --- htdocs/cgi-bin/config.cgi | 2 +- htdocs/cgi-bin/main.cgi | 4 ++-- htdocs/cgi-bin/wsrc/.main.js.swp | Bin 12288 -> 0 bytes 3 files changed, 3 insertions(+), 3 deletions(-) delete mode 100644 htdocs/cgi-bin/wsrc/.main.js.swp diff --git a/htdocs/cgi-bin/config.cgi b/htdocs/cgi-bin/config.cgi index 1ebb2c4..6765053 100755 --- a/htdocs/cgi-bin/config.cgi +++ b/htdocs/cgi-bin/config.cgi @@ -48,7 +48,7 @@ print $q->start_html(-title => "Personal Log", -my $stmtCat = "SELECT * FROM CAT ORDER BY rowid;"; +my $stmtCat = "SELECT * FROM CAT ORDER BY ID;"; $dbs = $db->prepare( $stmtCat ); $rv = $dbs->execute() or die or die "

Error->"& $DBI::errstri &"

"; diff --git a/htdocs/cgi-bin/main.cgi b/htdocs/cgi-bin/main.cgi index 5a0fb05..68f3c74 100755 --- a/htdocs/cgi-bin/main.cgi +++ b/htdocs/cgi-bin/main.cgi @@ -83,7 +83,7 @@ my $rs_cur = $q->param('rs_cur'); if($rs_keys){ my $stm = "SELECT rowid, ID_CAT, DATE, LOG, AMMOUNT from LOG WHERE"; - my $stmE = " ORDER BY DATE DESC, rowid DESC;"; + my $stmE = " ORDER BY DATE DESC;"; my @keywords = split / /, $rs_keys; if($rs_cat_idx){ $stm = $stm . " ID_CAT='".$rs_cat_idx."' AND"; @@ -102,7 +102,7 @@ if($rs_keys){ } elsif($rs_cat_idx){ $stmt = "SELECT rowid, ID_CAT, DATE, LOG, AMMOUNT from LOG WHERE ID_CAT='".$rs_cat_idx."'" . - " ORDER BY DATE DESC, rowid DESC;"; + " ORDER BY DATE DESC;"; } ############### diff --git a/htdocs/cgi-bin/wsrc/.main.js.swp b/htdocs/cgi-bin/wsrc/.main.js.swp deleted file mode 100644 index e023063cdcb2da4f91ed9fabc94912fdf957e559..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 12288 zcmeI2O^g&p6vqn`VFbkJ#e;|1R@feg?cG%pjpO7D9&uipDty{g)<`Jt(?ZTxm)6T|0P#vVDm{;_k*b#|n{Slw}5YF_Fyv1`k~(C|{d z7<-%?4$6|06+35(+F(iAz7-ByMQ0%Ic!TvYum;Pf;~CT8(%w`LrGQf4f)%LB!oVGC z*=@HD50TAHS|7jux?LA+t~x3OlmbctrGQdEDWDWk3Md7X0++u6va*alfi#vkQ+dAm zTsH67{Hh*G0i}RaKq;UUPzopolmbctrGQdEDWDWk3S5Q?m^Ndh_+|g-6$l>x|KIxk z|NC`}y${|16;K8a-(444A#TvzFNW9N8kkb02~L0z$>5x#=(PN4Cr7z(7^dC;S+oeo(2zt9bg?;3)X;N zux8GHFTiQ=Avgh!foMHlhV^hMhCItS4}`1+9xs?~D6%ZY3RTaNj_>iXnlC$YLe#gI zQWX85p{Mtw^w{8F%5+5_^}O_qn(0IG!hhono)V`%t)sU!iEj z-SjgMmK64wXN$di42fRZ$jmZj9O}|WQASx7nbpjI!xTncLwD@GIdsvW0m9>Ck?++X zg0%XlkQ7gpt5$3XJt^F_ct|G}FGa2k#*Apx{lE^}sc0HztTk+**RX}4oWmbMl_*Z^ zD(y)QL@4AG=BzonkImfwAKkfaA2W_kr7Qx)A$rC&5qqmCflh&rbwkkBk325 zE+&R@r$tZhs1QQ_p1|RbE91fte{H#GO1RSmkm zGF`X*s?%c}$D)Ih5{Rpp7PMqsA7zPRXs;KF{yx`jt(J?cfXutO!0Il;V(&Y(=v43` zXc4>IfjQITNSej^zl+j2^_N7>6WCbi?O>a2 zFZ95#V`ZQUsl=iW?OU{S@q8f68N7_XG+%OI%{?Bl^quC?qApHBM~~KF;_Qj{zO6gA zjq?%gFv7~!qHUz$2Rapx1N)(kd>W6$&TxfSl%*`*-o>Z0Jd<&v%_7w`Jz;mGBib@YxtMpT*%IL1l`@8+v%=0&kPqz3SFSRSK-&R42QbuEY7E>KZb`wJq|%R-vWvB z>fcEEH;1r#4N6Fct-2zPRPeR+}0d>VF(mK9~l`HGYAD{EsYVAQ;e)4N%10D39Y3N`HSC> zb#xg_^9>ttbx4A5HbYpN4P?`^IFi{w&unC3Q#w8BDKVj*bhAui#|BiMqF_wA_qGmV un!Gvpl&)I@T|ncTAl*-(Q)~tqx^F8