In mysql I have 2 date fields. Dates are stored in the format yyyy-mm-dd eg: 2004-11-26
I needed a condition where if the difference between the 2 date fileds is less than 5 days "NEW" appears. So i thought that if I convert the dates to a Julian dates I can compare them. The problem is that...
Hi,
I have installed Apache, Mysql and Php on my local machine. But to do this I had to disable Window's IIS.
The problem is that I have websites which reside on Apache servers thus I need to test my localhost on Apache and others on Windows thus I need also to test Windows server.
How can I...
I need to dump my table on the localhost so that I can rerun the script on the remote site using phpmyadmin.
The problem is that both tables (local and remote) have an autonumber field and thus cannot insert data in it. How can go about it?
Getting married in Malta?
Visit...
This function is working only if the first field beong check is left empty 'add.b_name', the others are being ingonored. Any idea why? I am not sure about the four } I have placed at the end, one for every if statement.
Thanks
function formCheck() {
var not_blank = true;
if...
Hi,
I have a form where it accepts a date inputted by users. I need users to input ONLY in dd-mm-yyyy format. What is the best way to do it?
I was thinking of having 3 list boxes for the days, months and years. But I need to check the inputted dates for invalid entries like for eg...
Hi,
I have a folder in my cgi which contains an emailing script. Due to data sensitivity (email addresses, etc...) I have set a password which prompts you before giving you access.
However, when I set a cronjob to run the script automatically, it failed because of the password. Can I give...
Hi all,
How can I convert a text record, dbrec("curvalue"), which contains for example 4.32 to a number with 4 decimal places, like 4.3200
I tried
formatnumber(cdbl(dbrec("curvalue")),4)
but I'm getting type mismatch cdbl.
Thanks
Mario
Getting married in Malta?
Visit www.TheWeddingSite.com
Hi
I have a server side include
<!--#include file="inc_search.html" -->
It works in asp and shtml but not in htm, html and shtm
Is this something my service provider can do?
Links are:
http://www.centralbankmalta.com/site/test_mario.asp
http://www.centralbankmalta.com/site/test_mario.shtml...
Hi,
Can anyone suggest a good website backup software, where I download the site only once and then it downloads only the files which have been changed since the last download.
Thanks
Mario
Getting married in Malta?
Visit http:www.TheWeddingSite.com
Hi there,
I once met, downloaded and deleted by mistake a script or some kind of software which permits website visitors to post appointments on an online event planner.
Users had to login first and then see/add/delete etc...their events. One person's events where not visible by another which...
Hi,
I need to populate a recordset from a tab delimited text file. However data is not of a fixed width as it contains
NAME...tab...SURNAME...tab...ADDRESS...tab... etc...
Can someone indicate me how I can do this please?
Best regards,
Mario
Getting married in Malta?
Visit...
Hi,
I send regular newsletter to my mailing list which definetely are not spam. However some anti spam software are stopping my emails from entering the server. The problem is that I do not know what X LIBRARY and X-MAiler in the message I am getting are (below)
SPAM: X_LIBRARY (2.2 points)...
Hi,
Does anyone knows how to extract the images of scanned documents from LN:DI?
On the net I read something about Image Processing Server (IPS) I am not sure if this is what we need. Is someone familiar with this.
What we need is to convert thousands of LN:DI documents to Tiff, Jpg or...
Hi all,
Hope someone can help me with this.
I have been given the (tedious) task to go to all our company's computers and replace the path of all application shortcuts we have created ourselves. We will be changing the name of the server/drive and folders and this is why we need to do this...
Hi all,
Hope someone can help me with this.
We have some applications which we have designed using VB6. The EXE's are found on the network:
For example //att/apps/app.exe
Now need to change the path to all exe's and make them for example //att_new/applications/app.exe
The problem is with...
Hi we have two servers...Sql 6.5 and Sql 2000.
Whilst many databases are on the 2000 we need to upgrade to the remaining few.
I tried to upgrade 1 database using the SQL UPGRADE WIZARD and it was successful. HOWEVER, the JOBS (backup jobs) which were found on the SQL 2000 were all overwritten...
Hi,
Don't know if this is the right forum to ask in, but does anyone know of anyone offering reliable free (or inexpensive) email service which I can offer to my visitors @my-domain.com.
I have come across http://www.zzn.com
Thanks
Getting married in Malta?
Visit http:www.TheWeddingSite.com
Hi,
I am installing a search engine on my website and the instructions say that I have to set permissions using TELNET and setperms.bat file given with the files. There is also a setperms.sh to be used on UNIX servers.
My servers is UNIX (there is something APACHE?!? It's hosted on...
Hi,
Maybe someone can help me with this pain of a problem.
I have a VB program which I designed. Nothing special, just combo boxes, Janus Grids and access to Sql Server.
I did the Setup files using the Package & Deployment Wizard of Vb6. I am installing the system on Windows 98 machines.
It...
Hi,
I have a "Back to Previous Page' link one using an image and the other a text link.
http://www.theweddingsite.com/bottombanner_new.htm
How can I make the cursor of the mouse change when on the image like it does when it goes over a link?
Thanks
Getting married in Malta?
Visit...
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.