Hi all,
I want to get the last date in a given month, eg, if I input February 2004, I want to return 28/03/2004 (or 29/02 if its a leap year).
Any ideas how I might go about doing this?
Thanks in advance,
Olly.
--
Olly
http://planetgnarly.com/
Its alright, its sorted now :)
It turned out to be a date formats problem.
I had to switch the dates (strFirstDate etc) around from DD/MM/YYYY to MM/DD/YYYY to make it work.
Thanks for your help anyway :)
--
Olly
http://planetgnarly.com/
SELECT * FROM Entries WHERE event_dayt BETWEEN #01/12/2003# AND #08/12/2003# ORDER BY event_dayt ASC
01/12/2003
08/12/2003
Which is returning nothing, even though there are records where event_dayt = 03/12/2003
Something screwy is going on, because if I change it to:
SELECT * FROM Entries...
1. No.
JPG loses quality becuase its a lossy format. PSD is not, so it doesn't lost quality.
2. It doesn't really matter - JPG doesn't support layers, so there is no need to flatten the image. Photoshop will do it automatically.
--
Olly
http://planetgnarly.com/
Unfortunately, plugin objects always sit on top of everything else and there isn't a great deal that you can do about it. Sorry :-(
IME, user's prefer to see stuff loading anyway, expecially on a slower connection - they like to know that something is happening.
--
Olly
http://planetgnarly.com/
There is no easy way. You can embed fonts on a web page, but its not widely supported and different browsers do it in different ways.
The best way is to accept the fonts users already have. I tend to use:
font-family: "Trebuchet MS", Verdana, Geneva, Arial, Helvetica, sans-serif...
Right, more progress.
If strLastDate falls into next month the whole thing falls apart, otherwise it works fine. Mumblegrumble.
--
Olly
http://planetgnarly.com/
OK, starting to make some progress now. strLastDate seems to be the problem.
WHERE fldYourdateField >= #" & strFirstDate & "#
Works fine - it returns everything after strFirstDate as expected.
WHERE fldYourdateField < #" & strLastDate & "#
Is borken. It returns nothing at...
BE WARNED!
Internet Explorer for Windows is the only major browser that won't let you resize your text when its set in pixels.
IE for MacOS, Netscape, Mozilla, Opera, Safari and Konqueror all let the user change their font size.
And IE users can set their default font size bigger (if for...
It wouldn't be something to do with date formats would it? I'm using DD/MM/YYYY - should it be MM/DD/YYYY or something?
--
Olly
http://planetgnarly.com/
In my experience if you put html code into the database, thats what it'll spew out.
Try putting the html code into the database. Now open the database in access and look at the code - is the html still there or just the plain text?
--
Olly
http://planetgnarly.com/
Mmm, as far as I can tell, your original code should work fine. Here's my version:
futureEvents.Source = "SELECT * FROM Entries WHERE entry_type = 'Events' AND event_dayt BETWEEN #" & DateValue(strFirstDate) & "# AND #" & DateValue(strLastDate) & "# ORDER BY event_dayt...
OK, perhaps its not so great after all :(
It appears to be picking up records upto and including strFirstDate, but nothing after that date. Any ideas?
--
Olly
http://planetgnarly.com/
We have an HP DJ1220C/PS here.
Its very good for fairly lightweight work (10 or so pages at a time), but when we start trying to print 70 or 80 pages at a time it becomes a little unreliable (stops picking up paper etc). But then I dont think it was ever designed for that sort of thing... :-)...
Hi,
I'm building a search results page.
I want to show the content of each search result, but I want to truncate it to the first 100 characters or so. In the example below, I would want the red bit truncated to 100 chars.
<li>
<%=(SearchResults.Fields.Item("entry_heading").Value)%>...
@lebisol - re DWWS
I'm agreed on the colour selection but he has a style switcher so you can choose darker/bigger text if you prefer.
The book is somewhat easier to read aswell :)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.