AwSDesigns 0 Newbie Poster

If you use a png for clipart or logos you can get file sizes smaller than gif with a custom palette. e.g. for a logo with a small number of colors reduce the number of colors and choose custom palette. Then you have smaller file sizes, plus better color representation.

No doubt about quality but the file size is still larger than giff. sure the png size that i posted is a tad larger than i could get if i sat at it for a while. BUT it will still be larger. If you know somthing SPILL IT!! NOW!! because i certainly cant get a png to beat a giff in size without total loss in quality!

AwSDesigns 0 Newbie Poster

I use Ulead Smart saver does a brillient job (also dimminishes file size)
photoshop is not very good at minimizing file sizes PSP also good but still not great
to stop the picture going fuzy save it as a "giff" rather!!!! png sucks for website graphics (its size) great format but is a bit bloated at least 1.5 times the file size of a jpg (better quality though) for that logo definately use "giff" and to reduce file size reduce colours used

Origional = 70705 bytes
giff = 8501 bytes
jpg = 9580 bytes
png = 44956 bytes

using Ulead Smart Saver Pro

there is no loss to quality

I know this might be a bit ilegel but check it out here
http://www.zoutnet.co.za/update/newsimages/newlogomockup.gif

AwSDesigns 0 Newbie Poster

Try this code not sure it will work in your case (not sure what you want to do)

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<form action="?" method="post" name="name" id="name">
<input name="name" type="text" id="name" value="<%= Request.Cookies("name") %>">
<input type="submit" name="Submit" value="Submit">
<% If (cStr(Request("Submit")) <> "") Then %>
<% response.Cookies("name") = Request.Form("name")
Dim dateplus4
dateplus4 = DATEADD("d",4,Now())
Response.Cookies("firstname").Expires=dateplus4%>
<meta http-equiv="refresh" content="0;URL=?">
<% End If %>

</form>
</body>
</html>

AwSDesigns 0 Newbie Poster

Got the answer!!!!


SELECT REPLACE(MAKE_SET(7,LPAD(Dayofmonth(Date),2,'0'),LPAD(month(Date),2,'0'),Year(Date)),',','')AS DateID From dateTable


it is a bit of a wired way but it works!
OUTPUT = 231104

AwSDesigns 0 Newbie Poster

Your hosting Probably doesnt have an access driver on thier system!
On your local computer you (i am sure) have access installed on your computer.
what error text is generated?

AwSDesigns 0 Newbie Poster

HI all
(Battled with the WORD – (probably wrong in these terms))
I have a field in an access database (DateInserted) and want to get a (DateID) field out of it.
To get the DateID field I use – Day(DateInserted)&Month(DateInserted)&Year(DateInserted) - (Unique key for date outputs as 21102004) my problem is that the & function does not work in MySQL.
The job I am busy with at the moment requires that I have this (newspaper’s website http://www.zoutnet.co.za news articles on a weekly basis – DATE IMPORTANT)
Question: how can I turn Day(DateInserted)&Month(DateInserted)&Year(DateInserted) as DateID into MySQL savy SQL
ANYONE THAT CAN HELP PLEASE, PLEASE DO SO!!!!

AwSDesigns 0 Newbie Poster

MySQL will happily work with ASP, which is why microsoft bundles the driver by default.
For a list of connection strings including one for mySql, see this thread:-
http://www.webforumz.com/topic.asp?TOPIC_ID=8

What MICROSOFT does NOT bundle the driver!! well not on XP home / Pro, 2003 server, or 2000 which version You use???? I needed to download the driver from MySQL website!