| |
| |
| |
|
Comments:
<0> asdf
<1> is there an easy way to find out what the last day of the month is, ie 28/29/30/31? without calling isdate on each and working backwards
<1> ?]
<2> day(dateadd("d",(-1),dateadd("m",1,"01 feb 2006")))
<2> ie add 1 month to the 1st of the month of interest then deduct 1 day
<1> oh bugga, i was hoping for something MaxDay or something, that would have been nice.. bugga
<1> but that will do :)
<1> thanks for that
<1> i definaqtly wouldnt have thought of that way
<3> day(dateserial(year(d), month(d)+1, 0)) works too
<2> mmm cerial
<4> mySQL - I have two tables.. one containing a list of images and with a categoryID attached to each image.. the other table is the categories.. how would an SQL look like that only would list those categories that actually contains a picture or more?
<2> select distinct categories from cats inner join list on list.catid=cat.catid
<4> uhm.. that wont work.
<4> it will list each category once.. thats all
<4> I want to list every category that contains an image.. meaning.. where count(images from ImageTable) > 0
<4> bigAl: something like "SELECT Categories.*, count(Images.*) AS amount FROM Categories WHERE amount > 0"
<2> SELECT categoryname as c, count(i.somefieldinimages) AS amount FROM Categories inner join images as i on (c.catid=i.catid) group by categoryname
<4> thanks
<2> iis, for a folder i added mime type .pmt = audio/x-wav
<2> but its sending text/html ??
<3> wtf.. apparently just over a couple weeks ago, the routine backup service was "uninstalled" from our server (probably a windows update)
<3> it's telling me to install it from add/remove programs and to "follow the directions on the screen" but i can find nothing related
<3> anyone know where it might be? win2k?
<2> the standard backup tool you mean?
<3> yeah, the one in disk tools
<3> hrm.. there's an ntbackup.ex_ in the i386 folder. i wonder if i can just copy that in
<3> hrm.. the actual ntbackup.exe was 0 bytes. this does not give me a warm and fuzzy
<2> cant see it, i didnt think it was optional tbh
<3> well it appears to be back up and running now.
<2> anyway to remove css for a checkbox after defining a style for INPUT ?
Return to
#asp
or
Go to some related
logs:
chopying
chat whit malta
#allnitecafe
#kl
mccloud06
#india
japonese chat
Melbourne Shuffler.torrent
#allnitecafe
2topac
|
|